2

Let's say there's a SQL job that runs a stored procedure every one minute.

What happens, if it takes more than a minute? Does it start the procedure again (having 2 of them running in the same time) or it waits for the previous to finish?

Richard
  • 106,783
  • 21
  • 203
  • 265
Ash
  • 1,269
  • 3
  • 25
  • 49

1 Answers1

2

A job can only have the status of running or not, a job that is already running won't start again.

Guffa
  • 687,336
  • 108
  • 737
  • 1,005