Script all jobs out in Sql Server 2005

January 23, 2008 · Filed under SQLServer, Technology

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 Comments »

  1. Sharon Xu Said,

    March 11, 2008 @

    Thanks. It works.

  2. Haidong Ji Said,

    March 11, 2008 @

    You are welcome, Sharon. Glad it helped.

  3. gondalez Said,

    May 2, 2009 @

    thanks, very helpful :)

  4. Haidong Ji Said,

    May 6, 2009 @

    Cheers gondalez. Glad it helped.

  5. Karthic Rajendiran Said,

    March 15, 2010 @

    Thanks, It Works…..

  6. Haidong Ji Said,

    March 16, 2010 @

    You are welcome Karthic.

  7. Nzc Said,

    May 13, 2010 @

    thank you very much sir

RSS feed for comments on this post · TrackBack URI

Leave a Comment

Page optimized by WP Minify WordPress Plugin