Post reply

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

  • February 25, 2021 at 12:54 pm

    #3850076

    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

  • February 25, 2021 at 1:06 pm

    #3850078

    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?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 25, 2021 at 6:09 pm

    #3850205

    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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • February 25, 2021 at 6:11 pm

    #3850206

    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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

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

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