| Author |
Topic |
|
aaroww11
Starting Member
12 Posts |
 Posted - 2011-05-13 : 05:24:36
|
| I create daily job which will execute on every 40 minutes.If the lest execution is on 23 40, the next execution will be in 00 00 becauseStart of the job is on 00 00.Can I create continues job which will always count 40 minutes? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-13 : 07:13:20
|
| on Job Schedule Properties page, select Daily as "Occurs" in Frequency section and on Daily Frequency section select Occurs Every 40 minutes--------------------------http://connectsql.blogspot.com/ |
 |
|
|
aaroww11
Starting Member
12 Posts |
Posted - 2011-05-13 : 07:21:07
|
| Well I described you how is working machanism you mentioned.That is not solution |
|
|
|
kumrejto.gopalak.
Starting Member
1 Post |
Posted - 2011-05-19 : 04:49:05
|
| what do u mean-? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-05-19 : 05:14:07
|
The only way I see is the following:Create as many entries in your Schedule list as needed.1. entry occurs once at 00:002. entry occurs once at 00:403. entry occurs once at 01:204. entry occurs once at 02:00...and so on.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
mhorseman
Starting Member
44 Posts |
Posted - 2011-05-20 : 03:33:56
|
| It seems to me that if your job start time is 00:00, then you won't get an execution at 23:40 - the last two of the day will be at 22:40 and 23:20. But if you need to have a job running at 23:40 and then 00:20, I think you need to set up the schedule as Daily, occurring every 40 minutes, starting at 00:20. I tried that on my test server last night and it looks right to me.Mark |
|
|
|
aaroww11
Starting Member
12 Posts |
Posted - 2011-05-30 : 03:29:06
|
| Thank you but that won't work if my interval is 38 minutes for example. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-05-30 : 05:55:57
|
| you want the job to run for every 38 minutes?? |
|
|
|
mhorseman
Starting Member
44 Posts |
Posted - 2011-05-31 : 03:30:14
|
| So at what times do you want this new "every 38 minutes" job to run?Mark |
|
|
|
aaroww11
Starting Member
12 Posts |
Posted - 2011-05-31 : 03:58:58
|
| The point is that I wolud like that job start in some period like 12:03 and set the interval like 38, or 37 minutes.I didn't found way to do that with one job and some calculations |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-05-31 : 04:23:36
|
quote:
Originally posted by aaroww11
The point is that I wolud like that job start in some period like 12:03 and set the interval like 38, or 37 minutes.I didn't found way to do that with one job and some calculations
when you are scheduling a job you need to fix a paricular time and interval on which you want the job to run... |
|
|
|
dujiaojing0
Starting Member
12 Posts |
Posted - 2011-06-02 : 06:49:27
|
| I was a little bit confused about the question...http://www.mssqlpasswordrecovery.com |
|
|
|
|
Create continues job