Home Forums SQL Server 2005 SQL Server 2005 General Discussion Determining Result of a job started with sp_start_job RE: Determining Result of a job started with sp_start_job

  • September 18, 2012 at 5:44 pm

    #1539329

    #1CoolGuy (10/26/2007)

    Thanks Vidhya but, If I am starting the job with sp_start_job I don't see how he "on error" in the SSIS package will help me.

    I figure I can query the sysjobhistory table to determine the last execution status for that job, however, this seems like a problem that lots of you SQL Experts would have run into in the past and I was wondering if there was a cleaner/ better way to do this that I am not thinking of.

    Thanks

    The SSIS package is running as a step in a SQL Server Agent Job, correct? You set it up so that if the package fails, the job step fails. You then have the as part of the failed job step that it runs another job step that emails all the appropriate parties that the process failed.