If I have a job in SQL Server 2005/2008, and it is scheduled to run every minute, what happens if one of the executions takes 75 seconds? Does the agent miss an execution or do I have two copies executing simultaneously?
asked
Multiple executions of SQL Agent Job
SQL Server will only run one instance of a job at a time. When a job runs past its next scheduled start time, that execution is skipped and the job picks up again at its regularly scheduled time.
When scheduling a job, you indicate a start date/time and then a recurrence frequency. If it is scheduled to run every minute, it will attempt to run at the beginning of each minute, but only if it is not already running. If it is running, it will start again at the beginning of the next minute after it stops.
The next execution would be skipped.
