What actually causes a SQL Agent job to run for the last time within the daily frequency settings?
I ask this because I have a daily job that does not always start. It is scheduled to run daily starting at 3:30 PM, repeat every 6 hrs, ending at 10:00 AM. That was intended to cause four executions during an 18 hour period (3:30 PM, 9:30 PM, 3:30 AM and 9:30 AM). Start time of 3:30 PM was selected because it is before SOD at the most Eastern site.
I have stopped that job and replaced it today with a similar job staring at 3:30 AM and ending at 10:00 PM, to see if midnight crossing is a problem. However, I have several other jobs that cross midnight without a problem and am wondering if the issue is interference between starting at, occurs every and ending at arguments.
The one difference I see with the job that does not always start is the daily starting time and the first repetition past the ending time are the same. I am wondering if reoccurrences do not end until the first repetition time after the ending time.
If I continue to experience missed starts, my next attempt will be to change the occurrence to ever 5 hrs and 45 minutes. That will provide a one hour gap between the first occurrence following ending time and the next start time.