I've read this great article By Mladen Prajdić about using the sql service broker to build a job scheduler in SQL server express.
But the link to the complete code seems to be dead.
Does anybody have the link and/or the complet code to share?
Hi Dennis, thanks for your reply. I'm using the windows scheduler now. But I'm running more and more procedures scheduled. Now using just one SQL file which calls the procedures.
The used table structure and procedures from the article, used to schedule are also interesting.
I am jet to make the choice how to initiate. Using windows tasks or service broker. Either way I want to switch to SQL tables and sprocs to manage the tasks recurrence and add error logging.