Personal WebSite of Leonardo Sasso

Select j.Name,

j.Enabled,

s.Step_Name,

s.Step_Id,

s.SubSystem,

s.Command,

s.DataBase_Name,

s.Last_Run_Time,

s.Last_Run_Duration,

s.Output_File_Name,

t.Next_Run_Date,

t.Next_Run_Time

From msdb..sysJobs As j

Inner Join msdb..sysJobSteps As s On (j.Job_Id = s.Job_Id)

left Join msdb..sysJobSchedules As t On (j.Job_Id = t.Job_Id)

Order By j.Name, s.Step_Id