Doyle ITS SQL Scheduler allows you to set up recurring SQL processes within your DotNetNuke portal, which can be queries or stored procedures, or even T-SQL statements! Each process can have any number of customizable schedules, and each execution is logged and stored for historical purposes. In addition to the regularly scheduled process executions, ad hoc executions can also be created. Doyle ITS SQL Scheduler integrates with the DotNetNuke Scheduler, which can also be configured to control how often pending processes are polled and executed.

Schedule setup for Doyle ITS SQL Scheduler is extremely flexible. Schedules can be created based on frequency - hourly, daily, weekly, weekdays, and monthly. For example, a process schedule can be every 1 hour, every 3 days at 4:00 PM, every 2 weeks, every Thursday, or every 4 months on the 1st of the month! Additionally, schedules can be scheduled in the future (effective date), or can expire (cease executing) on a given date, and the execution time gives you even greater control over process execution.

Process executions (instances) are scheduled after every previous instance is executed, with the exception of ad hoc (one-time) instances. Each instance retains the executed SQL, so if the process changes over time, you can still maintain history of exactly what was executed and when. Instance history can also be purged, to save database space.

Doyle ITS SQL Scheduler is a must-have administrative module for your DotNetNuke portal, giving you the degree of control over your data you have needed!

Live Demo: http://demo.doyleits.com/SQLScheduler/tabid/259/Default.aspx