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.
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy