I just tried changing the "To" address to another address I use
but that didn't help, either.

I just can't figure out what CF is hanging on once the email file
is generated...what it might be trying to do...I even shut off my email
scanning software...that wasn't it...

I wish there was some kind of trace function that I could turn on so that
I could watch the code as CF processes it...kinda like an old basic command
"Tron" or something like that, that I used to use to debug basic programs.

Then I could see what it's hanging on...

Rick

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

  I do not - aside from some email transport agents don't like the to and
  the from to be the same address - might try from="[EMAIL PROTECTED], and you
  can try slapping a timeout=" which might help to slow the bleeding.
  Other then that I am at a loss.

  Now that we know its mail, you might want to repost as a mail problem -
  that might get more eyes.

  On Tue, 2004-01-20 at 13:02, Rick Faircloth wrote:
  > Well...nothing I've tried so far works.
  >
  > And, yes, I've used cfmail in numerous projects that
  > are currently active, without any problems...
  >
  > Win 2000 Pro, CF 4.5.2
  >
  > Here's all the code that's in the scheduled task:
  >
  > <CFQUERY Name="Get_DSP_Addresses" Datasource="dsp">
  >
  >      Select CustomerID
  >      from emailcustomers
  >
  > </CFQUERY>
  >
  > <CFMAIL To="[EMAIL PROTECTED]"
  >                   From="[EMAIL PROTECTED]"
  >       Subject="DSP Email Newsletter Recipients">
  >
  > Dorchester Shooting Preserve has #Get_DSP_Addresses.RecordCount# email
  > newsletter recipients.
  >
  > </CFMAIL>
  >
  > See any problems?
  >
  > Rick
  >
  >
  >
  >
  >
  >   -----Original Message-----
  >   From: Rob Rohan [mailto:[EMAIL PROTECTED]
  >   Sent: Tuesday, January 20, 2004 1:45 PM
  >   To: CF-Talk
  >   Subject: RE: Trouble running scheduled task
  >
  >
  >   Are you using the cfmail tag elsewhere in the application with
success?
  >   If so can you see any difference between this cfmail and those? If not
  >   can you repost the your cfmail tag block and what email server type
you
  >   are using (I stupidly deleted the beginning of this thread and don't
  >   want to hit the archives) - this is cf4.5 too right?
  >
  >   On Tue, 2004-01-20 at 10:38, Rick Faircloth wrote:
  >   > 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