Share via

How can we schedule alert message when job fails in task sechudler in sql server

NN 0 Reputation points
2023-09-17T07:40:18.6533333+00:00

How can we schedule alert message when job fails in task sechudler in sql server

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,616 Reputation points
    2023-09-18T05:33:07.4+00:00

    Was this answer helpful?

    0 comments
  2. ZoeHui-MSFT 41,551 Reputation points
    2023-09-18T02:15:58.26+00:00

    Hi @NN,

    You may check it out here.

    https://stackoverflow.com/questions/40092097/generating-error-full-message-in-email-when-sql-agent-job-fail

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Was this answer helpful?

    0 comments
  3. Erland Sommarskog 134K Reputation points MVP Volunteer Moderator
    2023-09-17T09:56:57.6+00:00

    A quick search on Google found a couple of links. This one seems to be useful: https://www.c-sharpcorner.com/article/email-notification-on-sql-job-failure/

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.