Document Job Steps

How can I script out the job steps along with the DTS, Sp or T-SQL code within the step. This info must be stored somewhere. How can I access it?

Hi,

You can script out jobs, including their job steps, by using SQL Server Management Studio. In SQL Server Books Online, see the topic "How to: Script Jobs Using Transact-SQL (SQL Server Management Studio)"

The URL within the Books Online browser is

ms-help://sql90/udb9/html/fd9e6497-87ca-4da8-b194-55c9d5b03cec.htm

Copy and paste this URL into the Books Online browser to locate this topic. As an alternative, you can also search on the topic name.

Let me know if you have any further questions.

Best regards,

Laurel Hale