If you wanted more of a real-time effect, you could have the DTS package scheduled to run every minute.
The first task, in the DTS package, would be to check a value in a DB table to determine if the job should be run. If the job should not be run at this time, the DTS package ends quietly, without further processing. The value, in the DB table to determine if the package should run, would be set by a CF page. M!ke ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247557 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
