February 24, 2003 at 7:06 pm
This forum is for discussions of how to setup properly, troubleshoot, configure, and rant about SQL Server Agent. It's moderated by our good friend Rob Walters, who is a Product Manager at Microsoft.
Brian Knight
http://qa.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
February 25, 2003 at 1:14 pm
This is a great idea. But unfortunately, everybody post their questions in the Administration forum, what ever the question is.
February 25, 2003 at 2:26 pm
Administration is a broad topic, with 10,000 posts I thought it would be a good idea to break it out.
- Rob
- Rob
February 26, 2003 at 7:26 am
It'll take a while for everyone to get used to it, but I think it will be a good piece to split out.
Andy
February 26, 2003 at 7:15 pm
I schedule quite a few things using SQL jobs. I believe this is the same thing as the agent. Here are some things I found...
1. I ran a job from 11pm to 3am every day every 5 minutes. The job looked for a file and when the file arrived it was processed. The job could last anywhere from 5 minutes to an hour. I found that if the job ran before midnight and completed after midnight, even a minute after midnight, it would not run again, even though I wanted it to continue until 3am.
2. Based on number 1 it would be nice to be able to schedule tasks to start at a given time and then run for X amount of time while still having an interval to rerun. This would prevent the run from 11pm to 3am type routine. I would instead say run at 11pm for 4 hours and then restart every 5 minutes.
Just a thought,
Oh by the way I did call Microsoft Premier Support with this issue. I am waiting to see the technet article. 🙂
Thanks,
Bruce Szabo
Bruce Szabo, MCSE+I, MCDBA, MCSD
Bruce Szabo, MCSE+I, MCDBA, MCSD
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply