March 1, 2012 at 9:35 am
Hi guys, hopefully someone could point me in the right direction. We have configured several maintenance plans to backup our databases. In the properties of the sgent jobs we then set up notification to be emailed if the job fails. However that is not working. It was working at one point, but since we have moved to sp3 it stopped. Database mail has been configured and we are able to send test emails. The operator has been added, and also mail has been enabled on the sql server agent properties itself. we have tried restarting the agent, deleting and recreating the database mail setup. Also used our secondary exchange server. Both servers work when we send test emails by right clicking on the database mail menu in the SSMS.
we are able to get notifications using notification task within the sub-plans of the maintenance plans. However this should be working through the notifications through the agent jobs.
Below is our environment
sql server 2008 enterprise r2 64 bit
server 2008 r2 enterprise, running as a vmware client on a vmware 4.0 server.
March 1, 2012 at 9:55 am
Are you sure that the jobs are failing? I don't know your level of experience, so let me ask how you have determined that alerts should be sent; i.e. how did you determine that a job has failed?
Jared
CE - Microsoft
March 1, 2012 at 10:06 am
My error for not clarifying my earlier statement. The jobs are configured to only send alerts if they fail. However if we change the notifications to send an email if the job completes or succeeds emails are not being sent. So any alert condition completes, fails, or succeeds no emails are being generated. and after each change to the alerts i have made a point of restarting the agent service. But that also has no effect.
March 2, 2012 at 1:15 am
has the SQL Agent account been granted access to the profile you have created?
granted it should do this itself when you configure SQL Alert System profile but I have seen it go a bit funny from time to time.
also can you send mail to the operator via SSMS using exec msdb.dbo.sp_notify_operator and executing it as the SQL Agent account with that profile?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply