This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 54%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Requirement:
1. Suppose SQL agent get stopped in middle, how to send mail alert
2. Suppose TempDB got full. In that situation mail will be triggered based on reading event log message (not by sql agent job)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
You would need a 3rd party app monitoring the Windows Error Log. There are many of them, including SCOM from Microsoft.
Is there any way by reading extended events ?
Extended events can't trigger mail-sending on their own. Something would have to monitor the X-event session and react to it. And if Agent would stop all of a sudden that would not trigger any X-event at all, since that happens outside the Engine.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Hi @Rajkumar Sivanpandi
It seams you can run a Powershell script which will send an email and terminate (to avoid spam) if the SQL agent fails for any reason. Start the task again after restarting SQL Server to continue monitoring.
And here are some similar threads that you can refer to:
Send email alert when SQL Server Agent stops/fails
How to notify through DB MAIL when sql server agent stopped automatically?
Best regards,
LiHong