Get notifications on project task planned end is approaching in 10 days and lapsed.

[Yamja]

Hi,

I have a requirement that "Assigned to" needs to notify when the planned date is reaching in 10 days and planned end date is reached today for the project task form. Can some one please let me know how can I achieve this. I created an event registry and created a scheduled job, but I have hard time to write a script. I am new to ServiceNow scripting.

Can someone please provide me the script. date fields are "start_date, end_date".

Thank You.

[Yamja]

Hi,

I found the solution. this might help any body has same issue.

Created an Event> created a scheduled>wrote a custom script> create a notification.

Below is the script.

var args = {
'in 10 days ': 'sys_class_name=incident^state=2^end_dateRELATIVELT@dayofweek@ahead@11^end_dateRELATIVEGT@dayofweek@ahead@9',
'in 1 day' :'sys_class_name=incident^active=true^state=2^end_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()'
};
for (var v in args) {
run(v, args[v]);
}

function run(when, query) {
var in10d = GlideRecord('incident');
in10d.addNotNullQuery('end_date');
in10d.addNotNullQuery('assigned_to');
in10d.addActiveQuery();
in10d.addEncodedQuery(query);
in10d.query();
while (in10d.next()) {
gs.eventQueue('event name', in10d, in10d.assigned_to, when);
gs.eventQueue('event name',in10d,in10d.assigned_to, when);
}