How to create a task if the approval is pending for 7 days?

[Rakesh Behera]

Hi All,

I want to create task if the RITM approval is pending for 7 days. I have tried by using the scheduled job but

its only creating 1 task for all the pending approval. How can I create separate task for separate pending approval or

separate RITM approval.

Can anyone please help on this.

@Sandeep Dutta 

@Ankur Bawiskar 

@Mark Roethof 

@Maik Skoddow 

[Voona Rohila]

Hi rakesh

Can you share the script you tried?

[Rakesh Behera]

Hi Rohila

This the script I tried.

var gr = new GlideRecord("sysapproval_approver");
gr.addQuery('state', 'requested');
gr.addQuery('sys_created_on', '<', gs.daysAgo(1));
gr.query();
if (gr.next()) {
var sct = new GlideRecord('sc_task');
sct.initialize();
sct.short_description = 'Task to check with the approver ';
sct.assignment_group = '63f894991b090510f18ba8ade54bcbd7';
sct.description = gr.document_id.getDisplayValue();
// sct.request_item = current.sys_id;
sct.insert();

}

[Mark Roethof]

Hi there,

Instead of scripting this, have you considered a scheduled flow? This would involve zero scripting. Just clicking your logic together through the GUI.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Mahesh23]

Hi,

Make use of flow designer and follow the below steps

1.trigger service catalog

2.use lookup records action to search for all the approvals which are created 7 days ago and state is requested.

3.add for each loop action and followed by create catalog task action to create task.

Please mark my response as correct answer or helpful if applicable