Speedy Gonzales
Newbie
Points: 1
More actions
June 8, 2004 at 5:18 am
#108072
I still havent found a system or procedure which would backup all sql jobs with all their settings (owner, schedule etc.)
Is there anyone who has solved such a problem already?
rockmoose
SSCarpal Tunnel
Points: 4571
June 8, 2004 at 12:41 pm
#509548
To script the jobs:
In EM right click the Jobs icon under SQL Server Agent and choose Tasks -> Generate SQL Script.
Otherwise BACKUP the msdb database, which is where all the jobs are stored.
/rockmoose
You must unlearn what You have learnt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply