Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Question about job scheduling Rate Topic Display Mode Topic Options
Author
 Message
 Posted Monday, November 1, 2010 6:39 AM
 SSC Veteran Group: General Forum Members Last Login: Thursday, December 1, 2016 9:22 AM Points: 265, Visits: 457
 I have a job that I want to run every 20 minutes (because it takes about 15 minutes to run). When I schedule it, it shows that the job will run at x time (let's say 7:45), the job takes about 15 minutes so it should get done at about 8:00, but the next job run says it's going to be 8:20. Why doesn't it say the next job run will be 8:05? Isn't that particular job schedule supposed to go based on the start time of the job, not the start and end time?
Post #1013780
 Posted Monday, November 1, 2010 6:51 AM
 SSC Veteran Group: General Forum Members Last Login: Thursday, December 1, 2016 9:22 AM Points: 265, Visits: 457
 BTW - I found this documentation about the job schedule:[ @freq_subday_interval = ] freq_subday_intervalThe number of freq_subday_type periods to occur between each execution of a job. freq_subday_intervalis int, with a default of 0. freq_subday_interval is ignored in those cases where freq_subday_type is equal to 1.So does this mean that when the job has completed that it calculates that interval?
Post #1013787
 Posted Monday, November 1, 2010 7:23 AM
 SSCommitted Group: General Forum Members Last Login: Sunday, January 17, 2016 1:26 AM Points: 1,618, Visits: 21,012
 [b]When I schedule it, it shows that the job will run at x time (let's say 7:45), the job takes about 15 minutes so it should get done at about 8:00, but the next job run says it's going to be 8:20. When the job states that the next run is at 8:20, at that time what was the status of the job? Was it executing? Pradeep Adiga Blog: sqldbadiaries.comTwitter: @pradeepadiga
Post #1013806
 Posted Monday, November 1, 2010 7:31 AM
 SSC Veteran Group: General Forum Members Last Login: Thursday, December 1, 2016 9:22 AM Points: 265, Visits: 457
 Adiga (11/1/2010)[b]When I schedule it, it shows that the job will run at x time (let's say 7:45), the job takes about 15 minutes so it should get done at about 8:00, but the next job run says it's going to be 8:20. When the job states that the next run is at 8:20, at that time what was the status of the job? Was it executing?It had just completed (so it calculated 8:00 + 20 minute sub-day frequency)
Post #1013813
 Posted Monday, November 1, 2010 7:32 AM
 SSC Veteran Group: General Forum Members Last Login: Thursday, December 1, 2016 9:22 AM Points: 265, Visits: 457
 Ok, now it's doing it every 20 minutes from the start time like I wanted it to...I'm confused.
Post #1013815
 Posted Tuesday, November 2, 2010 8:56 AM
 SSCertifiable Group: General Forum Members Last Login: Yesterday @ 1:21 PM Points: 5,674, Visits: 8,201
 I hope you understand that if your job takes > 20 minutes to complete you will skip any 'overlapped' executions of the job. Best,Kevin G. BolesSQL Server ConsultantSQL MVP 2007-2012TheSQLGuru at GMail
Post #1014581
 Posted Tuesday, November 2, 2010 8:58 AM
 SSC Veteran Group: General Forum Members Last Login: Thursday, December 1, 2016 9:22 AM Points: 265, Visits: 457
 TheSQLGuru (11/2/2010)I hope you understand that if your job takes > 20 minutes to complete you will skip any 'overlapped' executions of the job.Yep.Right now, it's averaging about 12 minutes and I have the schedule setup to run every 15 minutes now. Haven't missed a 15 minute increment yet, and have run 94 times so far (it's a conversion job).It's not a big deal though if it goes beyond the 15 minutes.Thanks
Post #1014585

 Permissions