Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I really need help with this CFSchedule (really really)

Status
Not open for further replies.

awesomebeats

Technical User
Nov 29, 2001
25
US
Alright here's want I want to do. I simply want to have a scheduled event where the admin's can update the time at which it runs. So I have this code, eventually the start time and date will be taken from a db:
<cfschedule action = &quot;update&quot;
task = &quot;golive&quot;
operation = &quot;HTTPRequest&quot;
url = &quot;startDate = &quot;8/26/2002&quot;
startTime = &quot;02:08 PM&quot;
interval = &quot;Weekly&quot;
publish = &quot;No&quot;>
The problem is that the event doesn't run. Maybe I'm doing something wrong but all I want this page to do is run the code weekly on golive2.cfm. Is that really that hard, here's golive2.cfm:
<cfquery datasource=&quot;webcast&quot; name=&quot;golive&quot;>
update control
set status = 'on'
where type = 'livewebcast';
</cfquery>
Even when I go into CFAdmin and hit run task the db is not updated, the event doesn't run. I guess my real question is: HOw can I have a certain cfm run at a scheduled time? I thought this code would work, obviously I was wrong, I would greatly appreciate any suggestions and help. THank you very much.

-Awesomebeats
 
Use the FILE and PUBLISH attributes to troubleshoot this; that way you can see if there is any output after running the task.

Also, check the scheduler logs in the CF administrator before and after testing.

-Tek
 
I checked the log and this is what I get:
&quot;Error&quot;,&quot;968&quot;,&quot;08/27/02&quot;,&quot;09:29:22&quot;,,&quot;Status code for task: 'golive' is '401 Unauthorized'&quot;
I guess Win2000 is doing somehting I don't know, do you? I'll try with the file and publish attributes but I think its a secuirty problem or something. Thank you.

Awesomebeats
 
You don't by any chance have to login through NT authentication to your web server, do you? It sounds like you might have either basic authentication or windows digest authentication turned on, and whatever user (unless it's system) is logging on (or not logging on, which may be the problem) does not have access to that directory.

-Tek
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top