How to create schedule, program and job
Posted on 2009-04-07
My application should the program in three different shift. each shift have few managers. So I will create shift and assign manager for the shift. After that I will assign the program for each manager. Database should run the program whenever the responisible manger is active. Sometime I will send request to exeucte the program. that time if the manger is active then it should executed otherwise it should put it in queue and when the manager is active that time program should executed.
Please let me know how to achive this.