SQL Server Agent – How to Stop Job After Certain Hours

sql serversql-server-2008sql-server-2008-r2sql-server-agent

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.

Best Answer

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>' ;