I have a unique task that involves retrieving data from one server, moving it to another server, and then processing the data. I'm running CF8 on a linux server.
I wrote a ColdFusion program (call it template 1) to gather the data and write it to a MySQL database table. This program calls another ColdFusion program (call it template 2) which loops through the items in the MySQL database; each loop making a call to a PERL script passing parameters. The PERL sript telnets to another server passing the data and calling a program on the new server. This program writes the data to a file (for later processing) and control is returned back to the PERL script. The PERL script then redirects back to ColdFusion template 2, where the loop is continued until all the MySQL database table items have been processed. This process involves three servers, three databases, and three programming languages; one server is PICK based and therefore somewhat tricky to communicate with. This process runs fine when ran as a regular ColdFusion process, but when I run it as a Scheduled Task it fails to complete. I runs through one item but it seems as though the redirect from the PERL script fails. I understand that the Scheduled Tasks run as a 'CFHTTP' process and have attempted to run the process using a <CFHTTP> function and can't get it to work. I've never used <CFHTTP> and really don't understand what the premise behind it is. I want this process to run every morning and would like to have it run through a scheduler or as a CRON job. Does anyone have any ideas that may assist me? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
