>I have a template which i need to run on a regular basis, i have been told >that the scheduler in coldfusion is unreliable (although i havent >experienced this myself) and that i can use SQL server to schedule events i >wondered if this was true and what utility i use to do this.
Yes you can use SQL server to schedule jobs.
Enterprise Manager->"Server Name"->Management->SQL Server Agent->Jobs
From Menu: Action->New Job or Right Click in Jobs window -> New Job
The main information you need to enter is under the "Steps" and "Schedule" tags. Steps can be of various types, "Operating System command" and "Transact-SQL script" being the two I have used.
Bruce Ford b.ford@qut.edu.au Online Teaching Systems Coordinator Teaching and Learning Support Services Ph: +61 7 3864 9773 Queensland University of Technology
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
CF-Server
Bruce Ford