| Action |
The type of event being logged. Valid values are:- CREATEJOB: A job created by the CreateJob procedure.
- DROPJOB: A job dropped by the DropJob procedure.
- ALTERJOB: The schedule of a job changed by the AlterJob procedure.
- ABORTJOB: A job or job chain aborted by the AbortJob procedure.
- ABORTJOBADMIN: A job or job chain aborted by the AbortJobAdmin procedure.
- TRUNCATEHISTORY: Rows deleted from HistoryTbl by the TruncateHistory procedure.
- TRUNCATEHISTORYADMIN: Rows deleted from HistoryTbl by the TruncateHistoryAdmin procedure.
- STARTSCHEDULER: The Scheduler started by the StartScheduler procedure.
- STOPSCHEDULER: The Scheduler stopped by the StopScheduler procedure.
- SCHEDRUN: A scheduled job is run.
- RUN: A run-once job is run.
|
| ActionDetail |
Not used. |
| ActionUserName |
The name of the user running the job or calling the stored procedure. |
| JobId |
The number of the job. This is from JobTbl. |
| JobRunId |
The run number of the job. This is assigned by the scheduler. |
| UserName |
The name of the user who created the job. This is from JobTbl. |
| JobName |
The name of the job. This is from JobTbl. |
| ScheduleString |
A string representing when to run the job. This is from JobTbl. |
| RunEnabled |
A letter indicating if the job is enabled to run. This is from JobTbl. |
| SQLReqString |
The SQL request to run. This is from JobTbl. |
| NumOfSessions |
The number of sessions to use for the job. This is from JobTbl. |
| CommentString |
A description of the job. This is from JobTbl. |
| ScheduleType |
Specifies if the job runs on a regular cadence (REPEAT) or after a previous job (RUNAFTER). This is from JobTbl. |
| DefinedAfterJobType |
Indicates for a job that runs after a previous job finishes, if the job is to run if the previous job fails, completes, or succeeds. This is from JobTbl. |
| JobChainId |
Identifier for a job chain. |
| 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. |
| NumOfAfterJobs |
The number of after jobs of a job in a job chain. |
| RerunType |
Specifies if the job is to run again following a restart or failure. This is from JobTbl. |
| ScheduledRunTime |
The time the job is scheduled to run. |
| StartTime |
The time the job started. |
| EndTime |
The time the job ended. |
| RunStatus |
The status of the job run. Values are:- RUNNING: The job is running
- SUCCESS: The job completed successfully, the activity count is in ActivityCount.
- FAIL: The job failed. ErrorCode and Description have details.
- SKIP: The job was skipped. The Description column has details.
|
| ChainStatus |
The overall status of the job chain run. Values are:- RUNNING: At least one job is running.
- SUCCESS: The job entire chain completed successfully.
- FAIL: At least one job in the chain failed.
- SKIP: The job chain was skipped, Description has details.
|
| SessionType |
Indicator that the job was rerun because of a database restart. Values are SCHEDULED and RERUN WHEN RESTART. |
| AfterJobRunSkipped |
Status of an after job. Values are:- T if the after job was not run (for example because of a failure).
- F if the after job was run.
- NULL if there is no after job.
|
| ErrorCode |
The error code if the job failed, NULL otherwise. |
| Description |
A description of row. For job runs, an error occurs if the RunStatus is FAIL or SKIP. |
| ActivityCount |
The activity count for job runs if the RunStatus is SUCCESS, NULL otherwise. |
| HostId |
The host identifier of the session running the job. |
| SessionId |
The session identifier of the session running the job. |