Well...I change one task to query the db, then output to a file, without
sending an email...worked fine...output info was as expected.

Put the <CFMAIL> back in, after the text output line in the task, and
the info was written to the document properly, the email was generated
and sent to the spool, but the CPU still runs back to 100%, and the email
is only sent once I stop, then restrart CF...then the email is sent and
the correct info arrives in the email...

It's definitely got something to do with the email...

?????

Rick

  -----Original Message-----
  From: Rob Rohan [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, January 20, 2004 12:49 PM
  To: CF-Talk
  Subject: RE: Trouble running scheduled task

  Perhaps it is the mailing that's the problem not the scheduled task. Try
  doing the query and writing the task's output to a file and see if you
  get what you expect. If so we barking up the wrong tree.

  On Tue, 2004-01-20 at 09:37, Rick Faircloth wrote:
  > Hi, Rob...
  >
  > Yes, I tweaked that setting down to every 3 minutes and the log showed
that
  > that was working...all the tasks were updated and set to run at the
proper
  > time
  > according to the scheduler.log.
  >
  > I just tried setting two different tasks, both involving a query and
sending
  > an email.
  > According to the log, both tasks were submitted and ran properly.
  >
  > The first task as set to run at 12:08, then second at 12:10, once-only
for
  > both.
  >
  > The first task ran its query and generated the email, but didn't send
it.
  > It was a 1k email.
  > Two minutes later, the second task ran its query and generated the
email,
  > but it was a 0k email.
  > Realize that I had run both of these tasks and they had worked at
different
  > times, so it's not the code.
  >
  > Another twist, when I run the tasks manually now, they both generate the
  > email, but run the
  > CPU up to 100%...
  >
  > I don't know...perhaps it is the internal scheduled task list...maybe I
  > should just set it back to 15 minutes
  > and leave the tasks alone and see what happens...
  >
  > Any other ideas?
  >
  > Rick
  >
  >   -----Original Message-----
  >   From: Rob Rohan [mailto:[EMAIL PROTECTED]
  >   Sent: Tuesday, January 20, 2004 12:01 PM
  >   To: CF-Talk
  >   Subject: RE: Trouble running scheduled task
  >
  >
  >   oops didn't finish - from MM:
  >
  >   When scheduling a new event, you must set the execution time far
enough
  >   in the future for ColdFusion to update its internal scheduled task
list.
  >   By default, ColdFusion checks every 15 minutes for newly scheduled
  >   tasks. You can modify this interval using the Scheduler Settings page.
  >
  >   you might try using an interval of 15 minutes and see if that fixes
you
  >   issue.
  >
  >   --
  >   Vale,
  >   Rob
  >
  >   Immodica luxuria creat insaniam.
  >   Sanam formam viatae conservate!
  >   http://www.rohanclan.com
  >   http://treebeard.sf.net
  >   http://ashpool.sf.net
  >
  >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to