• Article Topics

  • Become a member of the SQLDBASupport community and receive notifications of new posts by email

    Join 82 other followers

  • Are you writer? Become an Author! Mail to

    amitvaid81 @ gmail dot com

  • Founder

    This is journey of a SQL DBA. I now work as a Sr. Database Architect and Solution Consultant, generally in performance tuning, clustering or high availability. The opinions expressed herein are my own personal opinions through real time experience.

    Amit Vaid

  • Advertisements

Script all jobs on SQL 2005 and 2008 Server

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.

Thanks 🙂



2 Responses

  1. what does it means…what is use of scripts…

    • Hey Bhanu,

      Thanks for your inputs on this article…

      Looks like you have never done any migration or upgradation..

      When there is a need to transfer all the jobs from one place to another we either have to transfer msdb database or other way we can transfer by script out all the jobs from one server to another.

      Thanks with regards


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: