Auto Close Problem after 7 days

[Mark Wood]

Hello Experts,

I am seeking guidance on a requirement to close problem tickets that have not had any incidents for 7 days. I attempted to fulfill this requirement using a scheduled job, but unfortunately, my script is not functioning as expected. Could someone please assist me with this? Thank you.

var prb=new GlideRecord('problem');
prb.addEncodedQuery('stateNOT IN106,107^related_incidents=0');
prb.setLimit(1);
prb.query();
while(prb.next())
{
prb.state=107;
prb.fix_notes=" test Scheduled Job";
prb.update();

}

[Dr Atul G- LNG]

Hi @Mark Wood 

Did you try with Flow designer, a low code way to do this. 

[Ankur Bawiskar · Accepted solution]

@Mark Wood 

script looks fine

did you try checking any mandatory field is blocking the update via data policy?

[Mark Wood]

Hello @Ankur Bawiskar,

The issue has been resolved; it was due to an exception in the data policy. Thank you @Ankur Bawiskar and @Dr Atul G- LNG for your assistance.

[Ankur Bawiskar]

@Mark Wood 

Glad to know.

Did you mistakenly marked your own response as correct?

My response pointed out the data policy point.

Would you mind marking my response as correct so that it benefits future readers.