There is one more way of doing this - moving both DTS packages and Jobs from the old server to new
server if you move the entire server.

You can restore the backup of the msdb database from the old server to the new server. This would
help you move all the DTS packages and jobs from the old server to the new server.

If you want to move a specific set of Jobs, You can use Enterprise Manager to script the jobs
required and move it to the new server.

Thanks
Ganapathy

--- "Ferguson, Keena" <[Email Address Removed] wrote:
> Once you have saved it on the new server you can reschedule it and that
> should set up a new job ... A little time consuming if there are a lot of
> them, but I really don't know of a way to move jobs ...
>
> Keena Ferguson
>
> Sr. Database Administrator
> Comdata Corporation
> [Email Address Removed]
> 615-371-3483
> www.comdata.com
>
>
>
> -----Original Message-----
> From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Sent: Wednesday, July 23, 2003 9:49 AM
> To: Ferguson, Keena; LazyDBA.com Discussion
> Subject: RE: detach & attach
>
>
> Thanks! Any idea about the jobs on the old server?
>
> -----Original Message-----
> From: Ferguson, Keena [mailto:[Email Address Removed] Sent: Wednesday, July 23, 2003 9:43 AM
> To: Fang, Elaine; LazyDBA.com Discussion
> Subject: RE: detach & attach
>
>
> Edit DTS and do a "save as" and signify the new server works for me ...
>
> Keena Ferguson
>
> Sr. Database Administrator
> Comdata Corporation
> [Email Address Removed]
> 615-371-3483
> www.comdata.com
>
>
>
> -----Original Message-----
> From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Sent: Wednesday, July 23, 2003 9:34 AM
> To: LazyDBA.com Discussion
> Subject: detach & attach
>
>
> Hi list,
>
> Does detach & attach include DTS package and job? If not, how can I move it
> over after attach?
>
> thanks,
> Elaine
>
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]


=====
Ganapathy Sankara Baaham
60 Strawberry Hill Ave
Stamford CT USA

If u can dream it,
you can do it.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
MS Sql Server LazyDBA home page