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

Asked

Viewed 243 times

3

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

How do I make the first step run completely?

sql sql-server
  • 1

    Impossible to answer without further details.

  • @Motta What more details you need?

  • Runs what ? What bases ? What "steps" are these ? What code ? Gives some error code ?

  • @Motta Executes a cursor that performs an update for each record. Returns no error.

1 answer

1

Log in to the SQL Server Agent properties (In the Object Explorer window) and you will see some settings:

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

Set the option to a longer time Shutdown time-out interval (in Second).

"Specifies the number of seconds that SQL Server Agent expects tasks to be completed before shutting down. If the job is still running after the specified interval, SQL Server Agent forcefully stops the work."

Shutdown time-out interval

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.