SQL Agent Step Notification

Hot Topic

How to : Truncation : Can i write a log entry whenever data is truncated?
message lost
autogrow of log file possibly cause timeout?
Preformance issue on Sql 2005 Analysis Services
SSIS will not start after SQL Server 2005 SP1 upgrade
Dynamically changing task name displayed within ForEach Loop Container
Getting the Location parameters from SSRS 2005
Manipulating dates in SQL
ADO Recordset from SQL Task issue
Stored proc in cache Permanently

SQL Server

Trying to setup ODBC link to SQL 2005 express
SMO Weirdness on SQLExpress box
Sql Server 2005 Express installation fails on OWC11 & Reporting Services
SQL Server Agent Jobs
Can't uninstall or reinstall SQL Server 2005 Dev
Date format in a merged field
ForEach Loop container issue!!!
CLR integration - Could not find Type '??' in assembly '??'.
SQL 2005 Cannot Drop User
Data Transfer from SQL200o to SQL2005

SQL Agent Step Notification

I have several SQL Agent jobs that each contain multiple steps.

I want the job to continue, even if one step fails, as they are not dependent on each other.

However, if I set it up so that the goes to the next step on failure, it appears that I have no way of being notified of the failure, since the job ends successfully.

Am I missing something Is there a notification that can be sent if a step fails

Thanks

Bob




Answer this question

SQL Agent Step Notification

  • cobain81

    See this http://www.sql-server-performance.com/dh_sending_sql_notifications_CDOSYS.asp is any help.


  • MarkBosley

    So, rather than having a step failure action for send mail, I will have to setup a second step for every step that I have... I was afraid of that. I have 22 steps now, making this solution a maintenance nightmare.

    To be honest, that's what I thought.

    MSFT- any chance of getting more granular on the notifications for SQL Agent Job Steps

    Thanks!

    BobP



  • WoFe

    If you could submit a suggestion on http://connect.microsoft.com/sqlserver that would really help. Suggestions from customers have added weight when we consider future enhancements for SQL Server. The Connect site inserts reported issues directly into our internal issue tracking system, so we are much less likely to lose feedback information if it is entered there.

    Thanks,
    Steve



  • hrubesh

    I have submitted the feedback/suggestion.

    The link is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=244623

    Thanks!

    BobP



  • SQL Agent Step Notification
Answer this question