Home Forums SQL Server 7,2000 Backups backup all jobs RE: backup all jobs
rockmoose
SSCarpal Tunnel
Points: 4571
More actions
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