SQL Server Agent Scheduled job fails i want to notify to manager mailid.

Question

SQL Server Agent Scheduled job fails i  want to notify to manager mailid. This i want to do  based on the message available in the scheduled job History.

Or  How can we bring into the database table that message

 

Thanks,

Thiruna

Answer 1

Hello Thiruna,

please note, this a SSIS forum.

This article may be a good starting point for you to create the solution: Returning full error details from SQL Server Agent jobs -

http://www.sqlservercentral.com/articles/SQL+Server+Agent/67726/

---

Arthur My Blog

Answer 2

Dear Mr. Thiru,

 

Bellow steps may help you

1. Open your Job Schedule and select Response option

2. Click on New operator and set values (operator name and e-mail and make sure "enabled" option is checked)

3. Click on View Job Button, then select Notification

4. Check Email option then select your operator name (from the list), and set select the option "When the Job Fails" from the list.

Have a nice day

---

Please mark the replies as answers if they help. Kumar

Answer 3

Hi,

Which version of SQL Server are you using? If you are using SQL Server 2005 or above, we can configure SQL Server Agent Mail to send e-mail message.
In addition to Kummar’s reply, we can also refer to the following link, please see:
SQL Server Agent Mail

Thanks,
Ai-Hua Qiu

---

Ai-hua Qiu[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.