Post reply

check to see if job has finished before job starts

  • June 23, 2015 at 5:10 am

    #309391

    I have a job I want to run everyday but before this job starts and I want to check and see if another job has completed before I start this job. i would like to do this in the job steps in SSMS. step 1 is job 'xxxxxxx' running if no go to step 2 if yes exit

  • June 23, 2015 at 5:27 am

    #1807298

    gchappell (6/23/2015)

    I have a job I want to run everyday but before this job starts and I want to check and see if another job has completed before I start this job. i would like to do this in the job steps in SSMS. step 1 is job 'xxxxxxx' running if no go to step 2 if yes exit

    As part of step 1, you can try interrogating the results from running

    EXECUTE master.dbo.xp_sqlagent_enum_jobs 1,''

    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

  • June 23, 2015 at 8:48 am

    #1807413

    There's a DMV as well: https://msdn.microsoft.com/en-us/library/ms190484.aspx

    We have an article as well: http://www.sqlservercentral.com/articles/T-SQL/77057/

  • June 23, 2015 at 9:03 am

    #1807422

    Thanks everyone I will check out both

    George

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

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