>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                                      [EMAIL PROTECTED]
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 [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to