Post reply

Recreating jobs on server

  • December 7, 2005 at 11:53 am

    #110403

    OK guys and gals...help me out here!!  Situation:

    DEMO Server crashes...IT gets things going....all jobs are lost.  In the sysjobs, sysjobhistory, sysjobschedules they are all still there but just not listed in the jobs directory.

    I script the jobs from another server (live site)...try to run it on the DEMO server.  Says they already exist!!  and keeps barking about the category type (uncatagorized[local]).

    Can I just delete them out of the system tables and try to run the script on that server????  What is the proper way to attack this?????

    Thank you!!!!!!! 

    Thank you!!,

    Angelindiego

  • December 7, 2005 at 12:01 pm

    #608241

    I would never recomend deleting anything from the system tables.  The proper way to recover these jobs would be to restore the backup of the msdb database of the server that crashed.  It almost sounds like your server is partially recovered.

  • December 7, 2005 at 12:07 pm

    #608242

    so if they are in the msdb database (which they are), how do I get to see them in the JOBS node under Managment/SQL Server Agent??????

    Thank you!!,

    Angelindiego

  • December 8, 2005 at 2:41 am

    #608347

    Have you restored the backup of MSDB before the crash?

  • December 8, 2005 at 9:23 am

    #608451

    Well, from the looks of things where I see the jobs in the system tables, I would say yes.  I cannot tell you that for sure, because it was the IT guys that did it and I haven't asked....but I will.....stay tuned!!

    Thank you!!,

    Angelindiego

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply