Quick Reference: Job Steps

There are other ways to do this, but the quick n easy way for me to get job and job step information is

  1. Get job names using

    EXEC msdb.dbo.sp_help_job

  2. Paste those names and surround them with single quotes, and preface each with

    EXEC msdb.dbo.sp_help_jobstep @job_name= '

  3. Hit CTRL-T for "results to text". (This makes it easy to browse and search, if a little less readable than the graphics pane.)
  4. Run, and browse the results.

 It's a very fast, very easy to remember way to search through job steps for certain code, or what have you.

Bonne beurre,

Jen McCown, http://www.MidnightDBA.com