How can i Trigger a notification for the Change request which are not closed.

[Atharvabx]

Hi Community,

I want to trigger a notification for change request which is not closed past 5 days of the Planned end date the notification should trigger 1st time after 5 days to planned end date whose change tasks are also closed and the same notification should trigger after 30 days for those which are still not closed. Please Help me with this taks.

also i am using a Event and a job schedular for triggering this Notification.

@ramsingh1234  @Ankur Bawiskar  @Chuck Tomasi 

[johnfeist]

Hi,

There are two ways to do this:

You can modify your flow/workflow so that after the change goes to Implement, you put a two pronged condition in place that either the change is closed or a timer set to release five days after the planned completion releases with the change unclosed.  If the change is closed you are done.  If it is still open when the timer expires trigger an event that will send the notification.  With the notification sent you have the same two conditions set up for your thirty day notificaton.

The other approach is to run two scheduled jobs after close of business.  One will query change_request for all changes that are open and five days past planed implementation.  The other will query for thirty days.  If the query gets any records, just loop through the records firing the appropriate event to send the notifications.

[Atharvabx]

Could you help with the schedule script  also the which will querry both the conditions .i am very new to servicenow, i am trying achieve this by using addEncodedquerry() but not getting the correct filter condition.  Please help me with this.  Thank you.