In Sql Server 2000, there is an option to script out all jobs in an instance. That option disappeared in Sql Server 2005.
You can still do it. In Object Explorer, click on Jobs folder. Then go to the Object Explorer Details window. All jobs in this instance will be listed there. Select all, and pick script jobs from the right click context window, and you will get all jobs in one nice script.
7 responses to “Script all jobs out in Sql Server 2005”
Thanks. It works.
You are welcome, Sharon. Glad it helped.
thanks, very helpful 🙂
Cheers gondalez. Glad it helped.
Thanks, It Works…..
You are welcome Karthic.
thank you very much sir