trigger email alerts in case file is delivered or failed for the job

  • Hi all,

    I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.

    I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not).

    Could you help me?

    Thanks

  • What sort of help do you want?

    christi1711 wrote:

    Hi all,

    I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.

    I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not). Could you help me? Thanks

    What sort of help do you want?

    What is an 'alter to' e-mail?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • Phil Parkin wrote:

    What sort of help do you want?

    christi1711 wrote:

    Hi all,

    I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.

    I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not). Could you help me? Thanks

    What sort of help do you want?

    What is an 'alter to' e-mail?

    Very much seems like a typo for 'alert to e-mail'.

    SQL DBA,SQL Server MVP(07, 08, 09) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."

  • Are you using SQL mail (sp_send_dbmail)?  If so, you can use the mail status table in msdb to check on the status of any email.  Look at the "sysmail_%" views.

    SQL DBA,SQL Server MVP(07, 08, 09) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply