JOB with 2 steps, first step stops when it reaches 1 minute of execution

3

I have a JOB configured in SQL to run every 30 minutes, it has 2 steps, 1 procedure in each step, but when the first step reaches 1 minute of execution, it quits without executing all the registers it should and starts the second step.

How do I get the first step fully executed?

    
asked by anonymous 30.10.2017 / 12:15

1 answer

1

Enter the properties of the SQL Server Agent (In the Object Explorer window) and you will see some settings:

  • General
  • Advanced
  • Alert System
  • JOB System - > Open this conf.

Set up for a longer time the Shutdown time-out interval (in second).

"Specifies the number of seconds the SQL Server Agent expects jobs to complete before shutting down." If the job is still running after the specified interval, SQL Server Agent stops working hard. " >

    
31.10.2017 / 18:02