Monday, February 20, 2012

Moving Jobs

How can I move scheduled jobs and DB Maintgenance Plan from one server to
another?
Thanks
EmmaEmma,
DTS has a Transfer Jobs Task. As for the DB Maintenance Plans...I'm not
sure.
HTH
Jerry
"Emma" <Emma@.discussions.microsoft.com> wrote in message
news:DE64BBD5-F072-476C-B2F0-E3D3E510247A@.microsoft.com...
> How can I move scheduled jobs and DB Maintgenance Plan from one server to
> another?
> Thanks
> Emma|||DB maintenance plans have to be re-created on each server. That is one
reason I prefer to do the same tasks in scripts.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Emma" <Emma@.discussions.microsoft.com> wrote in message
news:DE64BBD5-F072-476C-B2F0-E3D3E510247A@.microsoft.com...
> How can I move scheduled jobs and DB Maintgenance Plan from one server to
> another?
> Thanks
> Emma

No comments:

Post a Comment