RE: grrrrr ... CFSchedule
Here's the cfscheduler log: "Information","956","01/03/03","12:35:57",,"Scheduled task 'inserts8_clean_up' for URL request 'http://localhost/vcrecruitment/admin/inserts/qry_cleanup.cfm' initiated." "Information","956","01/03/03","12:35:57",,"Scheduled task 'inserts8_clean_up' for URL request 'http://localhost/vcrecruitment/admin/inserts/qry_cleanup.cfm' completed." (just the last of the eight tasks the "ran") Nothing happened. None of the expected actions actually took place. I set timeouts this time and I set enddate/endtime. H. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: grrrrr ... CFSchedule -- new question
OK ... I've the service Cold Fusion Application Server must pass a username/password to the shared network drive, is that sufficient for CFSchedule, or is there another service that needs a password set up? Or should it be set up in the tag/administrator? What is the Cold Fusion Management Service? Should that have password access to the server, same as the CFAS? What about the Executive, or RDS or any of the other CF services? H. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: grrrrr ... CFSchedule
I have had troubles running a scheduled template at midnight, try setting them for 5 after and then increment the rest of the tasks to run 5 minutes apart. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 12:25 PM To: CF-Talk Subject: RE: gr ... CFSchedule Only the last template in my sequence sends an e-mail. Here's what I'm doing ... Accessing a file on a shared drive/server, reading it and dumping into a database.* Then a template finds a bunch of pdfs (matched to the records in the database) and moves them to a temp folder. Then the images are renamed. Then ImageMagick converts the images to JPGs. Then some HTML files are made. Then everything is FTP'd to a publically accessible server. Then everything is cleaned up and logged (files deleted, an e-mail sent to the administrator (me)). Each of those steps is a scheduled tasks separated by five minutes, starting at 12:01 a.m. *CF has login permisson for the remote server/drive. H. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.435 / Virus Database: 244 - Release Date: 12/30/2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: grrrrr ... CFSchedule
Only the last template in my sequence sends an e-mail. Here's what I'm doing ... Accessing a file on a shared drive/server, reading it and dumping into a database.* Then a template finds a bunch of pdfs (matched to the records in the database) and moves them to a temp folder. Then the images are renamed. Then ImageMagick converts the images to JPGs. Then some HTML files are made. Then everything is FTP'd to a publically accessible server. Then everything is cleaned up and logged (files deleted, an e-mail sent to the administrator (me)). Each of those steps is a scheduled tasks separated by five minutes, starting at 12:01 a.m. *CF has login permisson for the remote server/drive. H. > -Original Message- > From: Joe Zanter [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 03, 2003 7:35 AM > To: CF-Talk > Subject: RE: gr ... CFSchedule > > Our admin had to enter a pw to give cfschedule the capability/permission > to > send emails. > > -- > Joe Zanter, Materials Lab, Woodward Aircraft Engine Systems > 5001 North 2nd Street, Rockford IL 61125 > ph 815-639-6312, fx 815-639-5104 > mailto:[EMAIL PROTECTED] > > Electric light is not the result of a series of upgrades to the candle. > > Date: Thu, 2 Jan 2003 11:03:00 -0800 > From: "Owens, Howard" <[EMAIL PROTECTED]> > Subject: gr ... CFSchedule > Message-ID: > <[EMAIL PROTECTED]> > > I first tried using CFSchedule a couple of years ago ... when I was still > running CF 4.01 on a 4.0 SP4 NTWS. Could never get it to work. Gave up. > > Hadn't tried again until this week. I'm using CF 5.0, on Win2K with IIS. > > I set up scheduled tasks up in the CF Admin. If I run them manually, > through the admin, they run fine. But as far as running on schedule, it > ain't happening. > > The scheduler.log file shows that the templates ran, but the results that > should have been produced at not their -- no e-mails sent, nothing written > to the application log, no database entries ... zilch. > > Any suggestions on why the scheduled events trigger but don't produce any > results? > > H. > > > ~~ > Howard Owens > Internet Operations Coordinator > InsideVC.com/Ventura County Star > [EMAIL PROTECTED] > AIM: GoCatGo1956 > ~~ > > *** > The information in this e-mail is confidential and intended solely for the > individual or entity to whom it is addressed. If you have received this > e-mail in error please notify the sender by return e-mail, delete this > e-mail, and refrain from any disclosure or action based on the > information. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: grrrrr ... CFSchedule
Good suggestion ... I'll try that. Since my initial post ... I deleted all of my tasks, rescheduled them for midnight and after (which is the real-life time I need them to run), and restarted the machine. scheduler.log says the tasks ran, but no results were produced (once again). H. > -Original Message- > From: Taz [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 03, 2003 12:30 AM > To: CF-Talk > Subject: Re: gr ... CFSchedule > > Does the script take a long time to run? If so, you might need to stick a > RequestTimeout on the URL string that calls the template in scheduler. > I've > noticed in the past that big tasks tend to time out running via CFSchedule > even though they don't require a RequestTimeout when accessed through a > browser... maybe scheduled tasks are low priority (?). > > Taz > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: grrrrr ... CFSchedule
Our admin had to enter a pw to give cfschedule the capability/permission to send emails. -- Joe Zanter, Materials Lab, Woodward Aircraft Engine Systems 5001 North 2nd Street, Rockford IL 61125 ph 815-639-6312, fx 815-639-5104 mailto:[EMAIL PROTECTED] Electric light is not the result of a series of upgrades to the candle. Date: Thu, 2 Jan 2003 11:03:00 -0800 From: "Owens, Howard" <[EMAIL PROTECTED]> Subject: gr ... CFSchedule Message-ID: <[EMAIL PROTECTED]> I first tried using CFSchedule a couple of years ago ... when I was still running CF 4.01 on a 4.0 SP4 NTWS. Could never get it to work. Gave up. Hadn't tried again until this week. I'm using CF 5.0, on Win2K with IIS. I set up scheduled tasks up in the CF Admin. If I run them manually, through the admin, they run fine. But as far as running on schedule, it ain't happening. The scheduler.log file shows that the templates ran, but the results that should have been produced at not their -- no e-mails sent, nothing written to the application log, no database entries ... zilch. Any suggestions on why the scheduled events trigger but don't produce any results? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ *** The information in this e-mail is confidential and intended solely for the individual or entity to whom it is addressed. If you have received this e-mail in error please notify the sender by return e-mail, delete this e-mail, and refrain from any disclosure or action based on the information.
RE: grrrrr ... CFSchedule
And assuming your are not running the English (Australia)n version there were indeed problems with CFSHEDULE, at least in the Administrator. These were apparently fixed in the latest update. I don't like putting a production server under the sort of load to really break CF - seems like I might have to - and break my own developer box in the process. You gotta love this job, eh? -Original Message- From: Taz [mailto:[EMAIL PROTECTED]] Sent: Friday, 3 January 2003 7:30 PM To: CF-Talk Subject: Re: gr ... CFSchedule Does the script take a long time to run? If so, you might need to stick a RequestTimeout on the URL string that calls the template in scheduler. I've noticed in the past that big tasks tend to time out running via CFSchedule even though they don't require a RequestTimeout when accessed through a browser... maybe scheduled tasks are low priority (?). Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: grrrrr ... CFSchedule
Does the script take a long time to run? If so, you might need to stick a RequestTimeout on the URL string that calls the template in scheduler. I've noticed in the past that big tasks tend to time out running via CFSchedule even though they don't require a RequestTimeout when accessed through a browser... maybe scheduled tasks are low priority (?). Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: grrrrr ... CFSchedule
I have been using probes for all my scheduled tasks since moving up to MX. Probes are under tools in CF5, but I don't know if they offer the same functionality. I realize of course they are probably the same underlying engine - but for some reason, I have not experienced any problem with probes even though they are the same tasks as were not being run as scheduled tasks. Well I have seen one problem - or quirk: probes that I have long since deleted still show up as failing in the MX Application log. I should figure out why, but keeps getting pushed to the back burner given that everything seems to be working fine. -j -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 3:51 PM To: CF-Talk Subject: RE: gr ... CFSchedule I have always tested my schedule scripts by having it email me at the end for testing, and executed it with CFSCHEDULE the first time around just to make sure it was completing. Very helpful when you are on a shared host and do not have access to the admin to make sure it was added correctly -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 12:48 PM To: CF-Talk Subject: RE: gr ... CFSchedule Howard Owens wrote: >Any suggestions on why the scheduled events trigger but don't >produce any results? I've always been able to get it to work, but the formula for success has not always been entirely straightforward. This may sound strange at first, but have you tried waiting for 24 hours to see if the thing kicks in? I've had my server monitor running for months on my home-based cf server. Then I had to fiddle with something in cfschedule (I forget what, exactly) for another task and suddenly the thing went dead as a doornail. Couldn't get it to restart despite tinkering with all kinds of stuff. After a bit I gave up and went on to other things, but was very surprised to see it had fired up again the next day, beginning at the start time of the event -- despite the fact that the starting *date* was in the past. I've also had success using '' action="UPDATE" '' in my cfschedule statement. All of the above is for CF 4.5.1sp2. As an aside MX scheduling behaved just fine after an upgrade overtop of cf 4.5x. Shots in the dark, maybe, but who knows... --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: grrrrr ... CFSchedule
I have always tested my schedule scripts by having it email me at the end for testing, and executed it with CFSCHEDULE the first time around just to make sure it was completing. Very helpful when you are on a shared host and do not have access to the admin to make sure it was added correctly -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 12:48 PM To: CF-Talk Subject: RE: gr ... CFSchedule Howard Owens wrote: >Any suggestions on why the scheduled events trigger but don't >produce any results? I've always been able to get it to work, but the formula for success has not always been entirely straightforward. This may sound strange at first, but have you tried waiting for 24 hours to see if the thing kicks in? I've had my server monitor running for months on my home-based cf server. Then I had to fiddle with something in cfschedule (I forget what, exactly) for another task and suddenly the thing went dead as a doornail. Couldn't get it to restart despite tinkering with all kinds of stuff. After a bit I gave up and went on to other things, but was very surprised to see it had fired up again the next day, beginning at the start time of the event -- despite the fact that the starting *date* was in the past. I've also had success using '' action="UPDATE" '' in my cfschedule statement. All of the above is for CF 4.5.1sp2. As an aside MX scheduling behaved just fine after an upgrade overtop of cf 4.5x. Shots in the dark, maybe, but who knows... --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: grrrrr ... CFSchedule
Howard Owens wrote: >Any suggestions on why the scheduled events trigger but don't >produce any results? I've always been able to get it to work, but the formula for success has not always been entirely straightforward. This may sound strange at first, but have you tried waiting for 24 hours to see if the thing kicks in? I've had my server monitor running for months on my home-based cf server. Then I had to fiddle with something in cfschedule (I forget what, exactly) for another task and suddenly the thing went dead as a doornail. Couldn't get it to restart despite tinkering with all kinds of stuff. After a bit I gave up and went on to other things, but was very surprised to see it had fired up again the next day, beginning at the start time of the event -- despite the fact that the starting *date* was in the past. I've also had success using '' action="UPDATE" '' in my cfschedule statement. All of the above is for CF 4.5.1sp2. As an aside MX scheduling behaved just fine after an upgrade overtop of cf 4.5x. Shots in the dark, maybe, but who knows... --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: grrrrr ... CFSchedule
Thanks, Michael ... tried this ... templates run fine without error. H. > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 02, 2003 11:33 AM > To: CF-Talk > Subject: Re: gr ... CFSchedule > > Use this to check if the url your calling is a good one or if it has any > errors. > The usual errors are environmental such as logins and the like. > > > > Scheduler Checker > Url to test: > > > > > >throwonerror="yes" > redirect="yes"> > #cfhttp.filecontent# > > > #CFCATCH.Message# > #CFCATCH.Detail# > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: grrrrr ... CFSchedule
No logging in ... no client or session variables ... pretty straightforward queries and such. Schedule to run once per day. H. > -Original Message- > From: Rob Rohan [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 02, 2003 11:26 AM > To: CF-Talk > Subject: RE: gr ... CFSchedule > > I have had some errors in logic when using the scheduler. Remember that it > is a new request and some things in your code may not be available if not > coded properly. > > i.e. if you are using the same page that a 'logged in' client would use, > there might be session variables set by the login process that the page > needs, etc. > > Other than that, I d'know. I have used the scheduler in 5.0 and MX with > little/no problem. > > Also remember that there should be about 15 minutes between each running > (at > least I have found that works the best). > > Rob > > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 02, 2003 11:03 AM > To: CF-Talk > Subject: gr ... CFSchedule > > > I first tried using CFSchedule a couple of years ago ... when I was still > running CF 4.01 on a 4.0 SP4 NTWS. Could never get it to work. Gave up. > > Hadn't tried again until this week. I'm using CF 5.0, on Win2K with IIS. > > I set up scheduled tasks up in the CF Admin. If I run them manually, > through the admin, they run fine. But as far as running on schedule, it > ain't happening. > > The scheduler.log file shows that the templates ran, but the results that > should have been produced at not their -- no e-mails sent, nothing written > to the application log, no database entries ... zilch. > > Any suggestions on why the scheduled events trigger but don't produce any > results? > > H. > > > ~~ > Howard Owens > Internet Operations Coordinator > InsideVC.com/Ventura County Star > [EMAIL PROTECTED] > AIM: GoCatGo1956 > ~~ > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: grrrrr ... CFSchedule
Use this to check if the url your calling is a good one or if it has any errors. The usual errors are environmental such as logins and the like. Scheduler Checker Url to test: #cfhttp.filecontent# #CFCATCH.Message# #CFCATCH.Detail# ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: grrrrr ... CFSchedule
I have had some errors in logic when using the scheduler. Remember that it is a new request and some things in your code may not be available if not coded properly. i.e. if you are using the same page that a 'logged in' client would use, there might be session variables set by the login process that the page needs, etc. Other than that, I d'know. I have used the scheduler in 5.0 and MX with little/no problem. Also remember that there should be about 15 minutes between each running (at least I have found that works the best). Rob -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 11:03 AM To: CF-Talk Subject: gr ... CFSchedule I first tried using CFSchedule a couple of years ago ... when I was still running CF 4.01 on a 4.0 SP4 NTWS. Could never get it to work. Gave up. Hadn't tried again until this week. I'm using CF 5.0, on Win2K with IIS. I set up scheduled tasks up in the CF Admin. If I run them manually, through the admin, they run fine. But as far as running on schedule, it ain't happening. The scheduler.log file shows that the templates ran, but the results that should have been produced at not their -- no e-mails sent, nothing written to the application log, no database entries ... zilch. Any suggestions on why the scheduled events trigger but don't produce any results? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: grrrrr ... CFSchedule
Have you run the url directly and gotten the desired result? If yes, then do the following. Write a CFHTTP to call the page and check the results. The internals of CFSCHEDULE use CFHTTP to do the work so if CFHTTP fails, the entire thing fails. > I first tried using CFSchedule a couple of years ago ... when I was still > running CF 4.01 on a 4.0 SP4 NTWS. Could never get it to work. Gave up. > > Hadn't tried again until this week. I'm using CF 5.0, on Win2K with IIS. > > I set up scheduled tasks up in the CF Admin. If I run them manually, > through the admin, they run fine. But as far as running on schedule, it > ain't happening. > > The scheduler.log file shows that the templates ran, but the results that > should have been produced at not their -- no e-mails sent, nothing written > to the application log, no database entries ... zilch. > > Any suggestions on why the scheduled events trigger but don't produce any > results? > > H. > > > ~~ > Howard Owens > Internet Operations Coordinator > InsideVC.com/Ventura County Star > [EMAIL PROTECTED] > AIM: GoCatGo1956 > ~~ > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.