Moving Jobs

Hi,

I am moving DBs from one server(say Server A) to other (say server B) & once everything moved i will rename the Server B to Server A.

-I am backing up from .bak file & .trn file.

Now, i am confused here..

How to trasnfer all jobs running on server A to server B?

I am really novice to DTS.

If some one can throw somelight on that,that will really helpfull for me.

With Regards.

Wasim

I'm not real clear on how you are moving the databases but you can script out the jobs on the old server and then execute the job scripts on the new server. If you are restoring msdb, script the jobs first, delete them on the new server after the restore and then execute the job scripts you created on the new server.

-Sue

|||just script the jobs and execute the script in new server......also you can restore the msdb in the new server in that case you dont need to script the jobs..........moreover you dont need to backup the trn file instead take a full backup and restore it in new server....|||

all server level objects like Logins/JObs/DTS has to be transfered explicitly.

(a) For dts you can use Save AS option or Save the DTS as filesystem object and transfer to Target server

(b) To tranfer the login you have a KB availbable in Microsfot site

(c) For Job , its always better to script the job from source and run it in target

Madhu