Howie,
I am logging the time. What is happeneing however is
that the templates are never being called. I know
this because I have a <cffile> writing some debug
output and that file IS NOT created.
If I run the scheduler template in the browser, the
file is generated without a hitch.
Additionally, it seems clear to me that the scheduler
is getting the wrong information about when events are
to run. I have 3 events in the database. One is
scheduled to run once a day and the other 2 are
scheduled to run once every minute. Those do
consistently run every 10 minutes. I do not see how
this can be a CF problem, but if you can tell me how
that might be possible then I am more than willing to
try and fix something on the CF side.
Here is my getEvents.cfm
<cfset FreqList="s,n,h,d,ww,m,yyyy">
<!--- Retrieve schedule --->
<CFQUERY NAME="GetEvents" DATASOURCE="ProbonoNet2">
SELECT ID,template,params,frequency,frequencytype
FROM ScheduledTasks
WHERE Enabled=1 AND
Next < getDate() AND
StartDate < getDate() AND
getDate() < EndDate
</CFQUERY>
<CFFILE ACTION="APPEND"
FILE="D:\ims\schedulertemplates\eventtemplates\data.txt"
OUTPUT="New Events: #GetEvents.RecordCount#
(#Now()#)">
<CFOUTPUT QUERY="GetEvents">
<CFFILE ACTION="APPEND"
FILE="D:\ims\schedulertemplates\eventtemplates\data.txt"
OUTPUT="Template: #Template#">
ID=#ID#
Template=#Template#
URLString=#params#
<!--- set up next event to prevent racing --->
<cfquery datasource="ProbonoNet2">
update scheduledtasks set
Next=#CreateODBCDateTime(DateAdd(ListGetAt(FreqList,Frequencytype),frequency,now()))#
where id=#id#
</cfquery>
</cfoutput>
<CFSetting EnableCFOutputOnly="NO">
result=OK
Here is my template that is SUPPOSED to be run every
60 seconds:
<cfoutput>#Now()#</cfoutput>
<!--- Query out the events requiring scheduling --->
<cfquery name="getMailings" datasource="ProbonoNet2">
EXEC Scheduler_GetMailings
</cfquery>
<!--- Create an object to load the data into --->
<cfset mailing = CreateObject('component','mailing')>
<!--- Loop over the mailings --->
<cfloop query="getMailings">
<cffile action="append"
file="D:\iMS\SchedulerTemplates\eventtemplates\mailings.txt"
output="Delivering MailingID: #id# (Definition:
#mailingDefinitionID#)">
<cfscript>
// Copy the row to the object
for (x=1; x LTE ListLen(getMailings.columnList);
x=x+1) {
col = ListGetAt(getMailings.columnList,x);
mailing[col] = Evaluate(col);
}
mailing.send('live');
</cfscript>
</cfloop>
I have extended logging enabled. I have placed errors
in this template, I have cleared the class files, I
have restarted the scheduler and all iMS services, I
have rebooted the machine.
In the end, the scheduler returns to this 10 minute
interval and fails to call the template.
If you would like to log into the box and look for
yourself I will be happy to give you the appropriate
info to term serv in.
Best regards,
Greg
--- Howie Hamlin <[EMAIL PROTECTED]> wrote:
> If it is being cached then CF is doing it. Try
> outputting the current date/time at the top and see
> if the caching
> stops..
>
> HTH,
>
> Howie
>
> ----- Original Message -----
> From: "Greg Narain" <[EMAIL PROTECTED]>
> To: "inFusion Support List"
> <[EMAIL PROTECTED]>
> Sent: Thursday, February 20, 2003 7:33 PM
> Subject: Re: [iMS] Scheduler Woes
>
>
> > Howie,
> >
> > The event is not meant to end. I had it scheduled
> for
> > every ten minutes and now the scheduler refuses to
> run
> > it at any other interval than ten minutes.
> >
> > I also put an error in the template that is called
> and
> > nothing is generated. I also even deleted all the
> > class files from CFMX and the ones for that
> template
> > were not re-generated.
> >
> > It seems like it is cached. But I even tried
> > rebooting the server. I added in another event
> also..
> > now I have two that are supposed to run every
> minute
> > and this is what I see:
> >
>
> <snip>
>
> >
> >
> > Any ideas?
> >
> > Greg
>
>
>
==^=======================================================
This list server is Powered by iMS
"The Swiss Army Knife of Mail Servers"
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [email protected]
==^=======================================================
