We have 14 scheduled jobs sitting on server A,. We are planning to move everything to Server B. We have SQL server 2000 on both the servers. Moved all the databases. Could someone tell me is there a way that we can move our jobs to server B from Server A or do I have to rewrite the jobs on Server B. Any help is appreciated! Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL jobs
- Thread starter lalitha1
- Start date
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
"We know nothing but, that what we know is not the truth..." - Me
mrdenny
Programmer
- May 27, 2002
- 11,595
Right click on the job, and script it out. Then run the job on the new server.
That or use DTS to move the jobs. There is a Copy Job object within DTS for just this task.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
That or use DTS to move the jobs. There is a Copy Job object within DTS for just this task.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question