Has anybody experienced this problem with the ColdFusion Scheduler ? I am not using <cfschedule>, just have created the schedule to run daily in ColdFusion Administrator. It's a highly database-intensive process, which dynamically generates and sends out daily email alerts.
9 times out of 10, it runs fine, requiring anything from 12-20 minutes for execution. However, in about 1 of 10 cases, the schedule executes partially or completely but doesn't exit. It continues to run and eventually times out, at the RequestTimeout interval specified in CF Administrator. It also pushes up CPU utilisation to 99%, and virtually hangs the machine, requiring a restart of the CF Application Server service. Has anyone experienced a similar problem or have any suggestions on troubleshooting it ? My scheduler refresh interval is 15 minutes, lower than the usual time of execution of this schedule. The requesttimeout period is set to a very high value, nearly 80 minutes. The template executed in the schedule contains some cfoutput tags, used for debugging purposes. However, the output from this template is not being logged. Could any of these be causing this hung process ? I am running CF 4.5 on Win 2K, IIS5, and SQL 2000 DB. Another question : Should we be using a .cfm script for a bulk mailing schedule that executes in the range of 9 to 24 thousand database queries, and dynamically generates anything from 3 to 8 thousand emails ? And this number will only grow with time. If not, what options do we have ? In fact this schedule was even more database intensive previously, but we moved a lot of queries to a java process, which populates certain tables for the use of the email alert schedule. Vishal. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
