howarkl
Grasshopper
Points: 12
More actions
September 19, 2003 at 11:24 pm
#65725
Does anyone know how to restore SQL 7.0 scheduled jobs. SQL Server crashed and after i restored the database the sheduled jobs were lost. The person who set this up did not script the jobs. Please help, I have a copy of the msdb.
5409045121009-7368
SSCoach
Points: 15740
September 20, 2003 at 3:01 am
#475149
Sheduled jobs are in the MSDB database.
You should be able to restore the MSDB database.
I think you'll have to stop SQLAgent before you try and restore MSDB.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply