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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Leave a Reply

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