Skip to main content
A
Akash299451589siy
Participating Frequently
June 13, 2023
Question

ColdFusion 2016 scheduled tasks not working

  • June 13, 2023
  • 1 reply
  • 171 views

Hi Everyone, I have created a scheduled job that deletes the data from db, when i access the file through browse it runs fine, but when i gave the url in schdule task in CFadmin it does not run, it shows that schedule task ran successfully but it does not run. 

Code in my cfm file: FormSubmit.cfm

<cffunction name="deleteFileFromDB" returnformat="plain"
access="remote">
<cfargument name="fileId" type="string" required="yes" />
        <!--- <cfoutput>Inside Model 2</cfoutput> --->
   <cfset myDataSource = "sds_dev" />
        <!---  <cfset myDataSource = application.datasource />--->
        <cftry>
<cfquery name="deleteFileDetails" datasource="#myDataSource#">
            DELETE
            from
             uploadFileTest
             where fileId='#arguments.fileId#'
        </cfquery>
<cfcatch>
                <cfoutput>Inside Model catch - #cfcatch.message# - #cfcatch.detail# </cfoutput>
                <cfabort>
            </cfcatch>
        </cftry>
<cfreturn arguments.fileId>
    </cffunction>
 
<cfset partsData = deleteFileFromDB('TestFileForFormIDAsForFinalTestCeasar1')>
Deleted File with id:<cfoutput>deletefileInDB</cfoutput>
 
It run fine when i access the file through browser:
like this, it gives the correct output.
But when i give this url in schedule task it does not run.
Please help.
    This topic has been closed for replies.

    1 reply

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    June 13, 2023

    Do any of the cf logs show anything at the time the task is run? If not, modify the task to have it save its output to a file. What does it show?

     

    Or create a cf page that does a cfhttp call to that url for the task, and cfdump the cfhttp scope. What does it tell you?

     

    A first guess is that the url is protected by a web server that implements windows authentication, which is not supported by cf scheduled tasks or cfhttp. This might be easily solved by putting the task in a separate folder with other means of protecting it (such as by ip address).

     

    (Other common problems stem from when the url is using https, and there are solutions for that, but you are not using that )

     

    Let's us know what you find. 

    /Charlie (troubleshooter, carehart. org)
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices