plc.myforum.ro

kosta · Member Joined: 09 Aug 2015 Posts: 161 Location: Salonic

Simple, open-source, fully customizable SQL Server scheduler
by Miljan Radovic,
Simple Dynamic Scheduler is alternative scheduling utility which uses SQL Server to store all configurations and logic. Main characteristics of Simple Dynamic Scheduler are:
Simple - Easy to manage (once you finish reading this page)
Dynamic - Not static
Purely T-SQL - says it all
Open source - Adoptable code to suit your business needs
Light-weight - Provides only decision machanism (Run or Hold) without actually executing anything

There are many schedulers today that can be used out-of-the-box, such as Windows Tasks, SQL Server Job Scheduler, 3rd party tolls, etc. But, consider following situations:

You are unable to use any of the out-of-the-box schedulers
You can use out-of-the-box schedulers, but it takes time and involves a lot of business processes (waiting for OPS or DBA) to add/modify/remove/disable/enable schedulers
It is not practical to făcute hundreds or thousands of scheduling tasks / jobs
Your scheduler should change, depending on certain business rules

If any of the situations presented above sound familiar, then Simple Dynamic Scheduler might be just the right solution for you.
Simple, open-source, fully customizable SQL Server scheduler Simple, open-source, fully customizable SQL Server scheduler

Simple, open-source, fully customizable SQL Server scheduler Simple, open-source, fully customizable SQL Server scheduler

http://www.codeproject.com/Articles/1096104/Simple-Dynamic-Scheduler

[URL=https://userscloud.com/akoez3wnc2a4]Create_function_f_SimpleDynamicScheduler_CheckRun.zip - 3 KB[/URL]
[URL=https://userscloud.com/gu7vgv08hsg8]Create_function_f_SimpleDynamicScheduler_Simulate.zip - 685 B[/URL]
[URL=https://userscloud.com/4vb6wa50lbo1]Create_table_t_SimpleDynamicScheduler.zip - 1 KB[/URL]