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...
> Hello,
> Can anyone tell me how to backup SqlJobs?
> Thanks.
> Jose.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment