July 13, 2004 at 7:24 am
Hi All,
I have two tasks that has the same start time. But in reality they start with a gap of 1 second. Is this the behavour of SQL Agent, If Yes..can I somewhere reduce the time gap
Levi
Jesus My Saviour
July 16, 2004 at 8:00 am
This was removed by the editor as SPAM
July 19, 2004 at 11:32 pm
Levi,
How are you scheduling your jobs? You can only specify hh.mm through Enterprise Manager. If you want it to start on hh.mm.ss you will need to use sp_add_jobschedule.
How are you checking the time the job started? Are you using Profiler?
Cheers,
Angela
July 20, 2004 at 10:14 pm
Angela,
I actually tried to create the jobs using the Enterpriser Manager. The Enterprose manager itself shows the time the job started "Last run time" there is a gap of exactly one second.
Levi
Jesus My Saviour
July 20, 2004 at 10:26 pm
Hi Levi,
Enterprise Manager will show seconds in the "last run time", you are right, but when you schedule it you can only specify minutes and hours, that's why it will not start at exactly the same time, only sometime during that minute.
If you need it to start on the second you should use sp_add_jobschedule to schedule your job.
Angela
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply