Scripting Jobs

  • I am running SQL2K, sp4. I have several jobs that run various scripts withing them (30+ steps). Does anyway have a nice little script that will pull all the details of each step? Some steps are executing 10+ sql scripts and I don't see the detail of each of them in sqljobsteps (I do see the execution of sproc but not individual sql statements!).

    -- You can't be late until you show up.

  • Brain cramp!:blush: Right click on the job and generate SQL scripts.

    -- You can't be late until you show up.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply