4

I have a scheduled job which runs nightly. I want it to stop itself at 07:00AM in the morning whether or not it is completed.
I have seen some duplicates in the site but they don't exactly address the problem. Thanks.

1 Answer 1

8

Personally I would create another job and schedule it to run each morning at 7am.

A job step within that job could execute something like

USE msdb ;
GO

EXEC dbo.sp_stop_job
    N'<Your job name>' ;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.