Export (0) Print
Expand All

dbo.sysjobactivity (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Records current SQL Server Agent job activity and status.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

session_id

int

ID of the session stored in the syssessions table in the msdb database.

job_id

uniqueidentifier

ID of the job.

run_requested_date

datetime

Date and time that the job was requested to run.

run_requested_source

sysname(nvarchar(128))

Who requested the job to run.

1 = SOURCE_SCHEDULER

2 = SOURCE_ALERTER

3 = SOURCE_BOOT

4 = SOURCE_USER

6 = SOURCE_ON_IDLE_SCHEDULE

queued_date

datetime

Date and time this job was queued. If the job is run directly, this column is NULL.

start_execution_date

datetime

Date and time job has been scheduled to run.

last_executed_step_id

int

ID of the last job step that ran.

last_executed_step_

date

datetime

Date and time that the last job step began to run.

stop_execution_date

datetime

Date and time that the job finished running.

job_history_id

int

Used to identify a row in the sysjobhistory table.

next_scheduled_run_date

datetime

Next date and time that the job is scheduled to run.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft