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

 

Regards

Ahmad Osama

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

Follow me on TwitterFollow me on FaceBook