October 23, 2024 at 10:50 am
What is the best way to continually loop a SQL Server Agent Job? I could set it to loop back to Step 1 as the last step. The issue with this would be that if the server was rebooted it would not auto start. Also if it stopped running how would I know. As well I have no requirement for this to run overnight. This is on a data import job set to every 10 minutes but I am wanting to tighten up on the timings.
Any thoughts ??
October 23, 2024 at 1:55 pm
Simply increase the frequency to every minute. The job won't kick off again if it is already running, if you know what I mean.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 24, 2024 at 12:08 pm
Yes I was thinking that driving home last night thanks for your backup to that. Makes the whole thing more manageable with schedules.
October 28, 2024 at 10:06 am
Works very well for anyone picking up this thread.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply