sys.sp_help_job

Description

Returns information about jobs that are used by SQL Server Agent to perform automated The job identification number. To view a specific job, either to return information about all jobs.

Syntax

sp_help_job
[ [ @job_id = ]
'job_id'
]
[ , [ @job_name = ]
N
'job_name'
]
[ , [ @job_aspect = ]
'job_aspect'
]
[ , [ @job_type = ]
'job_type'
]
[ , [ @owner_login_name = ]
N
'owner_login_name'
]
[ , [ @subsystem = ]
N
'subsystem'
]
[ , [ @category_name = ]
N
'category_name'
]
[ , [ @enabled = ] enabled ]
[ , [ @execution_status = ] execution_status ]
[ , [ @date_comparator = ]
'date_comparator'
]
[ , [ @date_created = ] date_created ]
[ , [ @date_last_modified = ] date_last_modified ]
[ , [ @description = ]
N
'description'
]
[ ; ]