Changes between Version 31 and Version 32 of DatabaseBasedAnalysis/Tables


Ignore:
Timestamp:
09/03/18 20:31:20 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis/Tables

    v31 v32  
    7474||='''Status''' =||= '''fStartTime''' =||= '''fStopTime''' =||= '''fReturnCode''' =||= '''Comment''' =||
    7575||=Waiting      =||  NULL              ||  NULL             ||    [NULL]           || Processing is supposed to be done (just not yet started or pre-conditions are still missing) ||
     76||=Scheduled    =|| --marker--         ||  NULL             ||    [NULL]           || Pre-conditions fulfilled, scheduled for processing by job-manager ||
    7677||=Running      =||  NOT NULL          ||  NULL             ||    [NULL]           || Processing is supposed to be done and running already  ||
    7778||=Success      =||  > 2000            ||  > 2000           ||     NULL            || Processing was successfully finished for this index    ||
    7879||=Failed       =||  > 2000            ||  > 2000           ||   NOT NULL          || Processing failed                                      ||
    7980||=Blocked      =||  < 2000            ||  < 2000           ||    [NULL]           || Processing is not supposed to run for this index       ||
     81
     82The marker '''--mark--''' is the special datetime `1971-01-01 01:01:01`.
    8083
    8184A corresponding query to get an overview of all index entries in a status table '''StatusTable''' could look like the following