Get SQL Server Agent job details

A DBA must be aware of what all jobs are scheduled and there details. To get SQL Server Agent job details, msdb.dbo.sp_help_job system stored procedure comes in handy.

1. To get all details of all SQL Server agent jobs.

1_Get SQL Server Agent job details

2.To get Job steps of a particular job

2_Get SQL Server Agent job details

3.To get job scheduled of a particular job

3_Get SQL Server Agent job details

 

Like us on FaceBook  |  Join the fastest growing SQL Server group on FaceBook

Leave a Reply

Your email address will not be published. Required fields are marked *