September 30th, 2003, 03:45 PM
How can I run a coldfusion executable through an NT batch program?
I generate some excel reports (basically are excel outputs of regular HTML reports) using the ColdFusion scheduler. How do I continue generating the same reports using the ColdFusion files but using the NT batch program instead of the ColdFusion scheduler?
October 1st, 2003, 10:45 AM
Not sure about the answer, but it might help to know that the CFSCHEDULE engine is, basically, an interface into the NT scheduled task engine, or the UNIX chron job engine. So as far as I know you can schedule whatever you need to run directly in the NT scheduled tasks. Now, how to tell it that you want to execute a URL as the task is another story...;-)
November 28th, 2003, 10:54 PM
you can use the windows scripting host.
Create a file with a .vbs extension with the following inside of it:
'Create an instance of IE
Set IE = CreateObject("InternetExplorer.Application")
'Execute your URL
Set IE = Nothing
Change http://urltoyourcfpage.cfm to the url to your cfm file. Then have the scheduled task execute that vbs file.