SQL Server Performance Forum – Threads Archive

Script out jobs

How can I script out all jobs in sql server 2005. It was easy to script all jobs at once in sql 2000, however not able to figure this out in SQL server 2005.

I tried but I don’t think there is any way other than using SQL SMO… You can also use SQL DMO…. http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

You could take help of ScriptTask in SSIS in this case, as of now there is only option to script each job or take backup of the MSDB database. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Yes you can do this, in Management Studio, click SQL Server Agent, jobs, then in the Object Explorer Details pane, select them all and then you can right-click, script them.

Thanks Thomas…. I have not checked object explorer details… Really good tip for me [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks Group

]]>