Scheduled Job for a task

[KouassiP]

Hello All , 

I have created an item in Snow and a task .

I have set the initial state of this task at 'On Hold' .

I want to change this state automatically from a date time (DD/MM/YYYY HH:MM) .

If this date is reached , the task will change the state from On hold to Active for example .

Could you please tell me if there is an existing field in the catalog tasks table or a buit-in solution to manage the scheduled job for a task ?

[KouassiP]

Hello @vaishali231  , the field taskGR.addQuery('u_resume_date', '<=', gs.nowDateTime()) doesnt exists on sc_task 

[vaishali231]

@KouassiP 

Yes, that's correct. u_resume_date is a custom Date/Time field used only as an example. It is not available Out of the Box (OOB).

You'll need to create a custom Date/Time field (for example, u_resume_date) on the sc_task table, store the date/time when the task should be resumed, and then use either a Scheduled Script Execution.

[KouassiP]

Hello @vaishali231  , indeed i was thinking about using the scheduled job for the script to update my task ... Do you know how it works in Snow ?