none
SSIS Email Alert when executing through a job RRS feed

  • Question

  • Hi ,

    I have an ssis package which sends an email after successful execution.It sends an email when i execute it from bids as wells as from ssms integration services.But when i execute the package by scheduling a job the package runs fine but it does not send an email on success.should I create a separate notification alert when it is executed through a job or there is any property that should be altered in my package.

     

    Regards.

    Friday, August 5, 2011 4:35 PM

Answers

  • Enable package logging so that you can see what messages are generated from the package.  If it's not sending emails when scheduled as a job, it's likely because the IS server can't see the SMTP server, or the account the IS package is being run under doesn't have rights to use the SMTP server.
    Todd McDermid's Blog Talk to me now on
    Friday, August 5, 2011 5:38 PM
    Moderator

All replies

  • Enable package logging so that you can see what messages are generated from the package.  If it's not sending emails when scheduled as a job, it's likely because the IS server can't see the SMTP server, or the account the IS package is being run under doesn't have rights to use the SMTP server.
    Todd McDermid's Blog Talk to me now on
    Friday, August 5, 2011 5:38 PM
    Moderator
  • Thanks Todd, You were right the account does not have rights to use the SMTP server.
    Friday, August 5, 2011 6:32 PM