• Without more details, I'd build a prototype job that looked something like this:

    IF EXISTS(SELECT STATUS FROM SOMETABLE WHERE STATUS='READY')

    BEGIN

    SET XACT_ABORT ON

    BEGIN TRAN

    EXEC PR_STEP1

    EXEC PR_STEP2

    EXEC PR_STEP3

    UPDATE SOMETABLE SET STATUS='DONE'

    COMMIT TRAN

    END

    ELSE

    BEGIN

    INSERT INTO TBLOG(MSG,MSGDATE) VALUES ('Status was not ready at this time',getdate())

    END

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!