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.
2.To get Job steps of a particular job
3.To get job scheduled of a particular job
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook
