How to set job execution shutdown (Enterprise Manager)
To set job execution shutdown
- Expand a server group, and then expand a server.
- Expand Management, right-click SQL Server Agent, click Properties, and then click the Job System tab.
- Under Job execution, in the Shutdown time-out interval (seconds) box, increase or decrease the shutdown time-out interval.
This determines how long SQL Server Agent will wait for executing jobs to finish before SQL Server Agent itself finishes.