View Single Post
  #5 (permalink)  
Old 07-03-09, 18:56
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,568
Since you have a trigger on the TASKS table anyway, why not attempting the wake-up in that trigger already? If the process is already running, the wake-up has nothing to do.

If you actually try to implement a scheduler that executes some tasks - independent of DB2, have a look at existing solutions. You could also regularly poll whether DB2 is running.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote