• johnwalker10 (8/24/2016)


    If you have any idea when this occured, you could take a look at agent's log file to see if anything bad happened. It's in a file called SQLAGENT.OUT, in a location like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG.

    Job deletions are not recorded in the SQL Agent error log.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass