How can I send an e-mail when the sql server job fails. I added my e-mail as operator and then in the job properties -> notification -> enabled the email. But it is not working. Any ideas?
Sql-server – Send Email when sql server agent job fails
sql server
Related Question
- Sql-server – sql server 2008 email notifications
- SQL Server 2008 – How to Send an Email When a Job Step Fails but Overall Job Succeeds
- Sql-server – SQL Server alerts not sending notification emails to the operator
- Sql-server – Can send test database mail but job emails failing
- Sql-server – job send email to developers upon complexion and include DBAs if it fails
- SQL Server – Cannot Find Job Associated with Active Email Notifications
Best Answer
For 2005 and 2008 you need to configure Database Mail then enable the Agent to use it (SQL Server Agent --> Properties --> Alert System). If problem persists, you can query the system tables related to Database Mail (check BOL for names of tables) for possible more information. If problems still persists you may need to work with your Exchange admin.
For 2000 you need Outlook installed.