Hi,

Can someone tell me how to move jobs to another SQL server?

Thanks.

In SQL Server 2000 DTS there is a task that will do this. You can also
script them out and apply them at the other server. Make sure you REPLACE
any references to the old server in the script before applying at the new
server.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"abc" <anonymous (AT) discussions (DOT) microsoft.com> wrote