July 20, 2004 at 8:55 am
I have a created a job schedule table and a schedule control similar (but not exactly) to that of SQL SERVER. I am however having problems trying to simulate the calcualtions for the next run date and time.
Does anyone out there know of the procedure(s) SQL SERVER uses to deteremine the next run date and time. Or can you at least direct me to where I can possibly find out. Maybe someone has already written something similar for SQL SERVER (or VB). Thank you in advance
July 21, 2004 at 4:09 am
Try this command in SQL Query Analyzer.
USE msdb
EXEC sp_help_job
You'll get all the details of the job schedules. This works with MSDE 2000. i'm not sure about SQL Server. You can find this in SQL Server Books Online.
Hari
July 21, 2004 at 6:41 am
Sorry... maybe I did not explain myself properly... I do not need specifically the result of the next run date... but rather on how it is calculated. That is to say, using the job specifications like FrequencyInterval , SubDayType and the like how does SQL SERVER come up with the next run date and time.
July 21, 2004 at 3:22 pm
try the dateadd function
it exists in both TSQL and VB but the parameters are different
[font="Courier New"]ZenDada[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply