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?
Link to article: http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express-2
Link to download (404): http://www.sqlteam.com/downloads/27002_SQLExpressScheduling_A2.sql
just wondering, why don't you use the window scheduler? It simple and you just run direct SQL to it via sqlcmd etc. much easier to manage?
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.
Best regards. Ron
Haven't seen @mladenp on this forum in a long time ... but this reference might wake him up!
Unfortunately it didn't wake up Mladen. Nobody out there who downloaded the scripts from the articles
Scheduling Jobs in SQL Server Express
Scheduling Jobs in SQL Server Express - Part 2
and can share?