Run-once jobs are deleted from JobTbl when the job completes.
| Column | Description |
|---|---|
| JobId | Job identifier created by the scheduler. |
| UserName | The name of the user who created the job. The user name is TD_OFS. |
| JobName | The name of the job. Job names are PurgeAllOldVersions and ReorganizeOFS. |
| ScheduleString | A string representing when to run the job. |
| RunEnabled | A letter indicating if the job is enabled to run. This is used when creating a sequence of jobs (job chain). |
| SQLReqString | The SQL request to run. The requests are CALL PurgeAllOldVersions and CALL ReorganizeOFS. |
| NumOfSessions | The number of sessions to use for the job. |
| CommentString | A description of the job. |
| ScheduleType | Indicator that the job runs on a regular cadence (REPEAT) or after a previous job (RUNAFTER). |
| DefinedAfterJobType | Indicator that a job that runs after another job finishes must complete or fail if the previous job fails. |
| BeforeJobId | For a job that runs after a previous job, the previous job’s identifier. |
| BeforeJobName | For a job that runs after a previous job, the previous job’s name. |
| RerunType | Indicator that the job must run again following a restart or failure. |
| NextRunTime | The next time the job is scheduled to run. |
| IsRunning | Indicator that a job is running:
|
| CreateTimeStamp | The timestamp when the job was created. |
| JobVersion | The job version number. Starts at 0 and is incremented by 1 for each AlterJob and schedule change jobs. |
| LastAlterTimeStamp | The timestamp when the job schedule was last altered. |