Post reply

email sent after scheduling ssis package

  • July 21, 2010 at 4:24 am

    #144194

    Hi Everyone..

    I have scheduled my SSIS packages in management studio,i want to send an email after the job has run successful,how can i do this.Can any one please suggest,its good for me.

    Regards..

    Anil..

    Regards..
    guru12

  • July 21, 2010 at 8:28 am

    #1196191

    Hi..

    Is there any way to send mail after the job runs sucessful.

    Regards..
    guru12

  • July 21, 2010 at 8:37 am

    #1196201

    Create a new step with T-SQL code to call sp_send_dbmail with the appropriate parameters to send your email.

    On the step with the SSIS pkg, have it fail the job if it fails, and have it go to the next step if it succeeds (the email step).

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • July 21, 2010 at 2:36 pm

    #1196498

    How about you go to the Notifications tab in the Job, check the box next to email, chose the operator and then select When the job completes.

    Easy.

    CEWII

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

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