DTS Package w/ Send Email

• cmcilvoy

  Ten Centuries

  Points: 1015

  More actions

  September 4, 2002 at 5:06 am

  #105190

  I have a DTS Package with Send Email on Success and also on Failure. It works fine when I execute manually. However when I scheduled the job it fails to execute the last step which is the email success or failure. I have the MAPI profile set up correctly. I was wondering if maybe I ned to create the jobs under a certain account. Not sure. thanks

  
  </cm>

• rgrimmel

  SSC Veteran

  Points: 281

  More actions

  October 2, 2002 at 11:35 am

  #437676

  Create the job under the same account that SQL Server Agent is running under.