May 20, 2003 02:20 PM

Generating Scripts for SQL Server Jobs

Rating: (0)
SQL Server Magazine
InstantDoc ID #38790

How can I generate scripts for all jobs running on my SQL Server? I want one script that includes all jobs and one script for each individual job.

You can use SQL Distributed Management Objects (SQL-DMO) to obtain a list of jobs. Use the JobServer object and iterate through the Jobs collection. To obtain each job's script, you can call the Scripts method for that job. Here's what you should do:

  1. Start Visual Basic (VB) 6.0.
  2. Start a standard EXE project.
  3. ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here