Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Copying jobs between servers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-02 : 07:36:32
BikerGary writes "Development server has vendor supplied month end job. What's the best way to copy this job to the production server?"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2003-07-02 : 10:23:35
Script the job from Enterprise Manager then connect to the production server and run that script in Query Analyzer.

Jeff Banschbach, MCDBA
Go to Top of Page
   

- Advertisement -