Post reply

Track source of SQL Agent error

  • December 10, 2014 at 8:19 am

    #397758

    I got forwarded a vague email that was generated by SQL Agent monitoring event. It was emailed to one user. My environment contains more than 100 SQL Server instances that I'm getting myself familiar with having started a week ago.

    Is there a faster way to track the source? Currently going to each instance looking for the operators tied to the user. Below is all the email contains(no other clues in the email):

    'Maintenance Plan Failure - User DBs - Back DB Trans Log'

  • December 10, 2014 at 8:30 am

    #1763803

    Is the FROM address not related to a server? Is it a shared address? This is one reason I don't want any shared accounts between servers.

  • December 10, 2014 at 8:43 am

    #1763814

    The FROM was a generic email account. BUT I figured out why it was so hard to track down. When 'Notifications' SQL Agent properties is not used to send email alerts, it is a pain in the neck to track such errors. In this case, the user had set up a 'Notify Operator' task in the maintenance plan and didn't include enough identifying details.

    Thanks,

    Matanda

Viewing 3 posts - 1 through 2 (of 2 total)

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