There are other ways to do this, but the quick n easy way for me to get job and job step information is
- Get job names using
EXEC msdb.dbo.sp_help_job
- Paste those names and surround them with single quotes, and preface each with
EXEC msdb.dbo.sp_help_jobstep @job_name= '
- Hit CTRL-T for "results to text". (This makes it easy to browse and search, if a little less readable than the graphics pane.)
- 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