Scheduling algorithm using MSSQL sysjobschedules
Ever tried to implement generic scheduling algorithms in one of your apps. ? sysjobschedules table in MSSQL 2000 is the place to start from. Learn the table and just write down your own algorithm for each type. And don't forget the interface. It will look like Scheduling jobs in MSSQL - SQLSERVER Agent interface. Enjoy :)
Friday, July 9, 2004 5:18 PM