Changes between Version 33 and Version 34 of DatabaseBasedAnalysis/Tables
- Timestamp:
- 09/03/18 20:32:55 (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis/Tables
v33 v34 74 74 ||='''Status''' =||= '''fStartTime''' =||= '''fStopTime''' =||= '''fReturnCode''' =||= '''Comment''' =|| 75 75 ||=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 ||76 ||=Scheduled =|| --''marker''-- || NULL || [NULL] || Pre-conditions fulfilled, scheduled for processing by job-manager || 77 77 ||=Running =|| NOT NULL || NULL || [NULL] || Processing is supposed to be done and running already || 78 78 ||=Success =|| > 2000 || > 2000 || NULL || Processing was successfully finished for this index || … … 80 80 ||=Blocked =|| < 2000 || < 2000 || [NULL] || Processing is not supposed to run for this index || 81 81 82 The marker '''-- mark--''' is the special datetime `1971-01-01 01:01:01`.82 The marker '''--''marker''--''' is the special datetime `1971-01-01 01:01:01`. 83 83 84 84 A corresponding query to get an overview of all index entries in a status table '''StatusTable''' could look like the following