Same problem...as soon as the task is set for recurring, the CPU
spikes to 100% after the email is generated and before it's sent.

Now I've got two tasks set to run once only...so I'll see if they execute
and send their mail properly...

Ideas concerning the recurring tasks?

Rick

  -----Original Message-----
  From: Rick Faircloth [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, January 20, 2004 11:44 AM
  To: CF-Talk
  Subject: RE: Trouble running scheduled task

  Interesting...I just set the scheduled task described below
  to happen only once, instead of every 5 minutes... the scheduled
  task ran without a problem.  The query ran, email was generated and
spooled,
  sent out, received, without any problem or CPU spiking.

  Now I've got the task set back to every 5 minutes...we'll see what
  happens...

  Rick

    -----Original Message-----
    From: Rick Faircloth [mailto:[EMAIL PROTECTED]
    Sent: Tuesday, January 20, 2004 11:04 AM
    To: CF-Talk
    Subject: RE: Trouble running scheduled task

    Yes, that was the first thing I checked.
    I ran into, and overcame, that problem a couple of years ago.

    Once the service is stopped, then restarted the 1k email goes out,
    is delivered and contains the appropriate message.

    Rick
      -----Original Message-----
      From: Robertson-Ravo, Neil (RX)
    [mailto:[EMAIL PROTECTED]
      Sent: Tuesday, January 20, 2004 10:21 AM
      To: CF-Talk
      Subject: RE: Trouble running scheduled task

      Hey, is the mail to be sent got anything in it?

      <sic>
      ColdFusion 4.5.1 SP2 (specifically) was the only version of ColdFusion
  to
      get hung on
      zero-byte mail written to the spool.  The file handle of the mail
would
    get
      written
      and ColdFusion would encounter some other runtime error that caused
the
      leaked file
      handle to be completed.  The secondary effect of this is that CF would
  get
      stuck
      sending out or moving the bad mail file and race the cpu.  1 cpu would
    spike
      to
      99-100%, and 2 cpu would spike at exactly 50% each.... flat line.

         _____

      From: Rick Faircloth [mailto:[EMAIL PROTECTED]
      Sent: 20 January 2004 15:24
      To: CF-Talk
      Subject: Trouble running scheduled task

      Good morning, all...

      Win 2000 Pro, CF 4.5

      I've ventured out of the box and decided to try and run my first-ever
      scheduled task.

      Here's the code I'm running:

      <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>

      The query runs fine, and the email is generated and sent to the
      spool folder, but once that happens the CPU runs up to 100%
      and the system sits there, email in the spool, until I stop CF in
    services,
      then restart...then the mail is sent, received, and contains
appropriate
      info.

      It acts like the same problem as a "0k email", but these are not
empty.

      Now, I don't have any other HTML code or anything on the
template...just
      what
      you see above.

      What could be the problem?

      Thanks for your help!

      Rick

      Rick Faircloth,
      Hinesville, Georgia
         _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to