1

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.

6

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, privacy policy and cookie policy

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