The Ji Village News

Script all jobs out in Sql Server 2005

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.

January 23, 2008

Haidong Ji

SQLServer, Technology

7 responses to “Script all jobs out in Sql Server 2005”

Sharon Xu says:

2008 March 11 at

Thanks. It works.
Haidong Ji says:

2008 March 11 at

You are welcome, Sharon. Glad it helped.
gondalez says:

2009 May 2 at

thanks, very helpful 🙂
Haidong Ji says:

2009 May 6 at

Cheers gondalez. Glad it helped.
Karthic Rajendiran says:

2010 March 15 at

Thanks, It Works…..
Haidong Ji says:

2010 March 16 at

You are welcome Karthic.
Nzc says:

2010 May 13 at

thank you very much sir

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Script all jobs out in Sql Server 2005

7 responses to “Script all jobs out in Sql Server 2005”

Leave a Reply