var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How-To Copy SQL Agent Jobs between servers
I need to move SQL Agent scheduled jobs from one server to another..
Here are the details:
SQL 2000 SP3 (upgraded from SQL 7)
Data stored in MsSQL7\Data
SQL Server 2000 SP4
Data Stored in \DATA\
DTS Packages have already been resaved on Target Server, how can I copy the scheduled jobs over?
Just create the scripts and run it on the other server.
Also you can backup msdb database and restore it on the other server