locked
SQL Server Jobs error: Unable to read event log RRS feed

  • Question

  • Hello world,

        I am trying to run a job that backs up my master database.  The job errors out with 'Unable to read event log.'  There are no alerts or notifications set and all SQL Services are currently running.  What am I missing

     

    Thanks

    MCA146

    Thursday, March 25, 2010 3:24 PM

Answers

  • For anyone concerned.  The T-SQL statement I was using in the backup database command had a date with a convert to a string.

    set @mydate=convert(varchar, getdate(),101 ).   This 101 format produces a date such as 3/10/2010.  SQL Server does not like the backslash characters.  It produces an error. 

     

     

    Thanks

    MCA 146

    • Marked as answer by mca146 Friday, March 26, 2010 9:27 AM
    Friday, March 26, 2010 9:27 AM