locked
Log File Question RRS feed

  • Question

  • If you see an error in your log file, is it possible to track that error back to which stored procedure produced the error?
    Wednesday, May 13, 2015 1:05 PM

Answers

  • Like this?

    That means the job is Disabled.

    If you open the Job Activity monitor you can see failed jobs, like this (Test2 has failed):

    • Marked as answer by IndigoMontoya Wednesday, May 13, 2015 2:52 PM
    Wednesday, May 13, 2015 2:43 PM

All replies

  • Can you elaborate your question once again? What sort of errors are you referring to ?

    Usually SQL Server error log file contains reference to SPIDs as well as Error description along with error level & severity so if you could explain your question bit more, we might be able to help


    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    Wednesday, May 13, 2015 1:09 PM
  • Can you elaborate your question once again? What sort of errors are you referring to ?

    Usually SQL Server error log file contains reference to SPIDs as well as Error description along with error level & severity so if you could explain your question bit more, we might be able to help


    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    It is the SQL Server Log File Viewer and I click the check box besides SQL Server Agent and it will display the Log file summary.  I have the Red circle with a white X in the center, date/time this error occured and what caused the error, but not what was being run that produced the error.
    Wednesday, May 13, 2015 1:18 PM
  • OK so what is the message description of the error you are seeing ?

    Can you paste the screen-capture here


    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    Wednesday, May 13, 2015 1:27 PM
  • Date:
    05/12/2015 10:30:00 AM

    Message:
    Message [298] SQL Server Error: 15404, Could not obtain information about Windows NT group/user [Removed User], error code 0x534 [SQL STATE 42000] (ConnIsLoginSysAdmin)

    Log Type:
    SQL Server Agent

    Log Source:
    Current - 05/12/2015
    Wednesday, May 13, 2015 1:34 PM

  • It is the SQL Server Log File Viewer and I click the check box besides SQL Server Agent and it will display the Log file summary. 

    Have a look at the Job Activity Monitor to see if there are any failed jobs listed there, that's what the agent reports on. You can then match up the failure time (via job history) to the entry in your log.

    From the description in the actual error it seems that the job owner may no longer exist or does not have sufficient permissions to run all aspect of the job. You can see the owner by right-clicking on the job and choosing 'properties'.

    Try changing the owner to 'sa' if the error persists. 

    Wednesday, May 13, 2015 2:28 PM
  • Does a red arrow pointing down in the bottom right corner of the picture (SQL Server Agent then Jobs) mean the Job failed?
    Wednesday, May 13, 2015 2:36 PM
  • Like this?

    That means the job is Disabled.

    If you open the Job Activity monitor you can see failed jobs, like this (Test2 has failed):

    • Marked as answer by IndigoMontoya Wednesday, May 13, 2015 2:52 PM
    Wednesday, May 13, 2015 2:43 PM