Monthly Archives: March 2018

SQL agent job details info

SELECT

job.job_id,

notify_level_email,

name,

enabled,

description,

step_name,

command,

server,

database_name,

schedule_id

FROM

msdb.dbo.sysjobs job

INNER JOIN

msdb.dbo.sysjobsteps steps

ON job.job_id = steps.job_id

INNER JOIN msdb.dbo.sysjobschedules sch

on sch.job_id = job.job_id

WHERE

job.enabled = 1