The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
SQL Server Admin Stuff
tralev
Registered User regular
Registered User regular
We're running SQL Server 2005, and simply put, I want to receive an email when a scheduled job fails. Seems simple enough.
I've configured database mail and tested it, it works ok good.
In the scheduled job I set it to email me when the job fails. Force the job to fail, but I don't receive an email. Go into the job history and it says the mail send to my email failed.
What step am I missing? Do I need to mess around with SQL Notification Services???
I've configured database mail and tested it, it works ok good.
In the scheduled job I set it to email me when the job fails. Force the job to fail, but I don't receive an email. Go into the job history and it says the mail send to my email failed.
What step am I missing? Do I need to mess around with SQL Notification Services???
Steam: tralev PS3: GeekMcD
tralev on
0
Posts
I'm wondering if the actual sql service is running under a different account though, and that account doesn't have permission... which is why it would work when I run it, since I do, but the service account doesn't...
I thought it was just running under the domain admin though, or at least the local admin...
Murphy's Paradox: The more you plan, the more that can go wrong. The less you plan, the less likely your plan will succeed.