cfschedule

[danarashad]

Does anyone know why this does not work, this is a scheduled task, that i am trying to get a simple email from. when i select run in the cfadmin, i get an error.
If I navigate to the url, it works. But when I try to run it in cfadmin. It doesn't work

<cfquery name="archive" datasource="#datasource#">
select ID from table where idstatus = 3
</cfquery>

<cfif archive.recordcount GT 0>
<cfmail to="dwilson@mail.org" from="dwilson@mail.org" subject="Archive works">
Test email
</cfmail>
Yes
</cfif>

The cfadmin looks like this.
Task Name: Archive
URL:

http://www.mysite.com/tasks/archive.cfm

username: username
password: password
file: D:\cf\task\archive.cfm

 

[GUJUm0deL]

What kind of an error do you get?

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[danarashad]

There was an error running your scheduled task. Reasons for which scheduled tasks might fail include:

The URL is a redirection URL.
The URL is protected by IIS NT Challenge/Response or Apache .htaccess password. The Username and Password text fields for editing a scheduled task are intended to support Basic Authentication only.
The Domain Name lookup failed. Try using the IP address of the domain whenever possible.
The URL is an SSL site, but the SSL port was specified incorrectly.
The Web site is not responding.
The directory specified for published results does not exist.

 

[ecobb]

The username and password set up in your CF datasource is not correct.


Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[jstreich]

select ID from table..."
You have a table named table? I don't think you can do that because table is a keyword.

[plug=shameless]

http://game-master.us/phpx-3.4.0/

[/plug]

 

[danarashad]

No I just changed it for posting reasons.