Import SQL 2005 Sever Agent Job\Packages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Vinod Devasia » Import SQL 2005 Sever Agent Job\Packages

Import SQL 2005 Sever Agent Job\Packages

Rate Topic

Display Mode

Topic Options

Author

Message

anvie

Posted Friday, February 27, 2009 3:36 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 14, 2012 3:37 PM
Points: 34, Visits: 110

I have 2 servers and they are mirrored. My concern is the SQL agent job are not excepted from mirroring.

Is there a way SQL agent jobs can be mirrored too?

Thanks!

Post #666039

Greg Charles

Posted Monday, March 02, 2009 10:35 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:50 PM
Points: 4,006, Visits: 4,847

Database mirroring only mirrors user databases. The only way I can think of to copy jobs is to build and schedule a script that scripts them and runs the script on the standby server.

I've found that jobs don't change that often so it's may be more efficient to just store the job scripts in some kind of version control store like Visual SourceSafe and update them when you make a change to a job.

Greg

Post #666736

anvie

Posted Monday, March 02, 2009 11:58 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 14, 2012 3:37 PM
Points: 34, Visits: 110

Thank you!

can you give me an idea or T-sql code on how to convert import sql server agent job. thanks!

Post #666796

Greg Charles

Posted Monday, March 02, 2009 2:30 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:50 PM
Points: 4,006, Visits: 4,847

Sorry, I don't have a T-SQL script for this because I've never needed to do it on an on going basis. I've only scripted jobs to as a one-time thing when migrating to a new server so I've just scripted them in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005).

Searching the SSC script section might turn up a script for you.

Greg

Post #666912

Jamie Longstreet-481950

Posted Monday, November 28, 2011 6:43 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:41 AM
Points: 2,440, Visits: 713

http://support.microsoft.com/kb/314546

Step 4: How to move jobs, alerts, and operators
Step 4 is optional. You can generate scripts for all jobs, alerts and operators on the source server, and then run the script on the destination server.
•To move jobs, alerts and operators, follow these steps:
1.Open the SQL Server Enterprise Manager, and then expand the Management folder.
2.Expand SQL Server Agent, and then either right-click Alerts, Jobs, or Operators.
3.Click All Tasks, and then click Generate SQL Script. For SQL Server 7.0, click Script All Jobs, or Alerts, or Operators.

Jamie

Post #1212464

« Prev Topic | Next Topic »

Permissions