How to send notification based on time interval

[Nag9]

In my req

I want to send notifications to the owner of the story, if state changes to UAT and testing will not happen upto 2 days.

So need to set reminder for the story owner after 48 hours , still story testing pending 

I created event and business rule but its not wrking

Can anyone help me out on this

[asifnoor]

For 2 days, we cannot build encoded query directly. you can try something like this.

var gdt = new GlideDateTime();
gdt.addDays(-2);
var gr = new GlideRecord("rm_story");
gr.addQuery("state=1"); //place value of UAT here
gr.addQuery("sys_updated_on","<",gdt);
gr.query();
while(gr.next())
{
    gs.eventQueue('your_event_name',gr,gs.getUserName(),gs.getUserID()); 
}

Mark the comment as helpful if it helps.

[ravi32]

On hold reason = waiting information and   Follow up = true mails are receiving every time interval but the problem is

for testing purpose , if I run scheduled job for 1 hour , when one INC0010077 is updated at 9:00 AM and another INC0010078 updated at 09:30 AM the  scheduled job runs with both tickets sending notification at a 10:00 Am time, but second INC0010078 send notification at 10:30.not sending at correct time.

var gr = new GlideRecord("incident");
gr.addEncodedQuery("active=true^state=3^hold_reason=6^u_automatic_follow_up=true");
gr.query();
while(gr.next())
{
 
gs.eventQueue('Automatic follow up', gr, gr.getValue('user'));

}

[ravi32]

On hold reason = waiting information and   Follow up = true mails are receiving every time interval but the problem is

for testing purpose , if I run scheduled job for 1 hour , when one INC0010077 is updated at 9:00 AM and another INC0010078 updated at 09:30 AM the  scheduled job runs with both tickets sending notification at a 10:00 Am time, but second INC0010078 send notification at 10:30.not sending.

[srinathgtrk]

For last working 3 days, last working 5days and 7 days, how could we? write the condition?