MS SQL Server - dts to copy jobs

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

dts to copy jobs

Tom Reis

2006-03-27, 1:23 pm

We are upgrading our SQL 2000 Enterprise Server to a new server running the
same. When using DTS to transfer the jobs from old server to new 4 of them
will not transfer over to the new server. It just gives a unspecified error.
Any ideas?

Andy Price

2006-03-27, 8:23 pm

You can generate a script for the jobs instead, through Enterprise Manager
(right click a job name, and it is under Tasks). Just run the generated
script on the target server.

--
Andy Price,
Sr. Database Administrator,
MCDBA 2003

"Tom Reis" wrote:

> We are upgrading our SQL 2000 Enterprise Server to a new server running the
> same. When using DTS to transfer the jobs from old server to new 4 of them
> will not transfer over to the new server. It just gives a unspecified error.
> Any ideas?
>
>
>

Sponsored Links