Deleting ColdFusion Scheduled Tasks With CFThread And CFSchedule

Posted December 29, 2008 at 12:09 PM

Tags: ColdFusion

If you can remember this far back, a little over two years ago I stumbled upon the odd fact that in ColdFusion a scheduled task cannot delete itself. As a very hacky work around to this, I came up with a way to use ColdFusion's CFHTTP tag to have the scheduled task launch an asynchronous request that was able to delete the original scheduled task. This worked, but is clearly not ideal. Now, with ColdFusion 8's CFThread tag, we have a much cleaner way to launch asynchronous tasks. As such, I figured I would take a few minutes to see if it could be used to delete scheduled tasks.

I created a scheduled task named, "CFThreadDelete," that calls this template ever 61 seconds (ColdFusion scheduled tasks cannot fire more often than 61 seconds):

 Launch code in new window » Download code as text file »

  • <!--- Get the file path of our log file. --->
  • <cfset strLogFile = ExpandPath( "./log.txt" ) />
  •  
  • <!---
  • Log task output. We are doing this so we can see when the
  • task fires and whether or not the CFSchedule tag successfully
  • deleted the task.
  • --->
  • <cffile
  • action="append"
  • file="#strLogFile#"
  • output="Triggered: #DateFormat( Now(), 'HH:mm:ss' )#"
  • addnewline="true"
  • />
  •  
  •  
  • <!--- Check to see if we should delete this task. --->
  • <cfif (RandRange( 1, 3 ) EQ 2)>
  •  
  • <!---
  • Delete the scheduled task. Since a task cannot delete
  • itself from the same thread, we need to launch a seprate
  • thread to actually execute the CFSchedule tag.
  • --->
  • <cfthread
  • action="run"
  • name="DeleteTask"
  • logfile="#strLogFile#">
  •  
  • <!--- Log the deletion attempt. --->
  • <cffile
  • action="append"
  • file="#ATTRIBUTES.LogFile#"
  • output="Deleted: #DateFormat( Now(), 'HH:mm:ss' )#"
  • addnewline="true"
  • />
  •  
  • <!--- Delete the task. --->
  • <cfschedule
  • action="delete"
  • task="CFThreadDelete"
  • />
  •  
  • </cfthread>
  •  
  • </cfif>
  •  
  •  
  • <p>
  • Task Done Executing
  • </p>

As you can see, each time the template runs, I am logging the request to a text file. Then, I randomly generate a number to see if we should delete the current task. If, by chance, we need to delete the task, I am launching a parallel thread using ColdFusion 8's CFThread tag. This asynchronous process then logs the delete request and uses CFSchedule to delete the named task.

After letting this run for about 10 minutes, I checked the log file:

Triggered: 11:12:48
Deleted: 11:12:49

Looks like the task ran once and, by chance, deleted itself on the first run. Now, since I left it to run for 10 minutes, I am quite confident that the task is not still running. The ColdFusion Administrator also reports the task as no longer existing.

Looks like ColdFusion 8's CFThread tag can be used to quite elegantly delete scheduled tasks that want to auto-distruct.

Download Code Snippet ZIP File

Post Comment  |  Ask Ben  |  Other Searches  |  Print Page




Learning ColdFusion 9 - ColdFusion 9 tutorials, samples, examples, demos

Reader Comments

Dec 29, 2008 at 2:22 PM // reply »
2 Comments

I got intrigued by this post, as it struck me a little too complex for something that should be fairly simple.

I have never had any issues just inserting the code to delete the scheduled task inside the actual task, so it deletes itself when it is done.

Here's some older info I reposted from my notes. http://blog.shortfusion.com/index.cfm/2008/12/29/Dynamic-Scheduled-Tasks-With-ColdFusion#more


Dec 29, 2008 at 2:31 PM // reply »
25 Comments

Hi Ben,

I always like seeing new ways of using cfthread, but I have to second Alex on this. This may be new to CF8, but I've also managed to have a scheduled task delete itself (it's actually the first thing I do in the task).


Dec 29, 2008 at 2:32 PM // reply »
7,572 Comments

@Alex,

Interesting post. The way you have it set up, it doesn't matter. Without a parallel thread, when you scheduled task deletes itself, it does successfully remove itself form the ColdFusion Admin; however, the task will continue to execute on its existing scheduled basis until the ColdFusion service is restarted.

However, since your task interval was "ONCE", even if the scheduled task hangs out in memory (as it should with the "bug"), it will never fire again. If you changed your task to something reoccurring, you would probably experience some issues.


Dec 29, 2008 at 2:32 PM // reply »
7,572 Comments

@Francois,

See my previous comment. I wonder what repeating occurrence your tasks have.


Dec 29, 2008 at 2:35 PM // reply »
25 Comments

@Ben,

Ah, there you go. I imagine the little detail about the interval "bug" was in your previous post. My bad ;).


Dec 29, 2008 at 2:44 PM // reply »
7,572 Comments

@Francois,

No worries my man. And to be honest, I have only ever dealt with tasks that happen on a regular basis. It's certainly possible that there is no bug for one-off tasks. Perhaps the mechanism for how the task interval is defined is where the bug is.


Jim
Dec 29, 2008 at 6:46 PM // reply »
16 Comments

Hi Ben,

I'm wondering if you have had any experience using alternative scheduling software?

I recently took a look at Quartz (http://www.opensymphony.com/quartz/), and I may end up using in one of projects. I really like the fact that it solves all the inherent weakness of scheduled tasks, e.g. proper queuing, flexible start times (no 61 second wait).

Integration may be a bit of a challenge, so I'm wondering if you have any different recommendations?

Thanks,

Jim


Dec 29, 2008 at 9:17 PM // reply »
7,572 Comments

@Jim,

I have not tried anything else.


Sep 9, 2009 at 7:18 AM // reply »
5 Comments

I am having an issue now that even if I delete a scheduled task in the admin. It keeps firing off and the old scheduled interval. Even restarting CF doesn't help. As a temporary measue I have just deleted the template it is trying to run but every two minutes I get an entry in application log that it cannot find the file.


Sep 12, 2009 at 10:52 PM // reply »
7,572 Comments

@Don,

Sounds like the config file that stores the scheduled tasks is corrupted or something?? Very strange. If restarted the ColdFusion service doesn't get rid of it AND it's no longer in the ColdFusion admin, then something very odd is going on.


Post Comment  |  Ask Ben

Recent Blog Comments
Mar 19, 2010 at 7:26 PM
MySQL 3/4 - com.mysql.jdbc.Driver And allowMultiQueries=true
Thank you very much for this post. Adding allowMultiQueries="true" in context.xml didn't help until I added it to url as allowMultiQueries=true Good idea is to use prepared statements and it will he ... read »
Jim
Mar 19, 2010 at 4:49 PM
Nobody Puts Baby In The Corner!
Wow. This is like suddenly finding a support group for your secret shame. I'm not alone! I always liked this movie, even though it is extremely cheesy. I just wish Jennifer Grey hadn't gotten the ... read »
Mar 19, 2010 at 4:47 PM
Application.cfc OnRequest() Method Affects OnError() Arguments
@Jason and @Ben, I've been doing some CF9 refactoring on our systems and noticed an odd occurrence with onError as well. Found a way to work around my problem, but what I saw was... Background: Our ... read »
Jim
Mar 19, 2010 at 4:44 PM
Shoot 'Em Up Starring Clive Owen And Paul Giamatti
I actually enjoyed this movie quite a lot. It was different, certainly, but I think they were going for more of a Quentin Tarentino-"wow, that was weird"-vibe than an actual spoof. Once I realize ... read »
Mar 19, 2010 at 4:34 PM
An Intensive Exploration Of jQuery With Ben Nadel (Video Presentation)
Hey I guess the video is down. Is there anyway you can upload to youtube or vimeo or some other service? Greatly appreciated. ... read »
Mar 19, 2010 at 4:24 PM
ColdFusion CFPOP - My First Look
@Ben Thanks for the follow up! The root of the problem had to do with being able to trace bounced emails to specific records in a DB table. Let's say you run an email campaign and you get 1,000 bou ... read »
Mar 19, 2010 at 4:15 PM
SQL COUNT( NULLIF( .. ) ) Is Totally Awesome
Thank you Ben and Tony! Either of these work for the summary report I am working on and the info is much appreciated! I think I like Tony's a little better because I won't have to educate every ... read »
Mar 19, 2010 at 3:35 PM
ColdFusion Path Usage And Manipulation Overview
@Ben, Sorry. Clarification. expandpath worked for me in application.cfc, but not in other templates. ... read »