Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import SQL 2005 Sever Agent Job\Packages Expand / Collapse
Author
Message
Posted Friday, February 27, 2009 3:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, March 2, 2009 10:35 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:41 PM
Points: 4,065, Visits: 5,297
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
Posted Monday, March 2, 2009 11:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, March 2, 2009 2:30 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:41 PM
Points: 4,065, Visits: 5,297
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
Posted Monday, November 28, 2011 6:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
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 »

Add to briefcase

Permissions Expand / Collapse