Tuesday, March 27, 2012

Backup SqlJobs

Hello,
Can anyone tell me how to backup SqlJobs?
Thanks.
Jose.Hi ,
Best way is to backup the MSDB database as a whole. This includes all the
jobs, alerts, operators, and backup and restore history.
Otherway is to script out the jobs by high lighting all jobs and then right
click and select all taks. There you can select "Generate sql script" and
save it to hard disk.
Thanks
Hari
MCDBA
"Jose Ines Cantu Arrambide" <joseine@.nospam.com> wrote in message
news:OH8nL$O5DHA.2392@.TK2MSFTNGP10.phx.gbl...
quote:

> Hello,
> Can anyone tell me how to backup SqlJobs?
> Thanks.
> Jose.
>

No comments:

Post a Comment