Scheduled Job not triggering event for notification, when there is no time card record for the user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-07-2022 11:06 AM
Hi, we need to get a notification on the end of the week, when forgot to submit time sheet for this week. So I followed below link to write a scheduled job and created an Event and Notification.
But I am getting error that parm1 is not defined.
Scheduled Job:
var gr = new GlideAggregate('sys_user_grmember');
gr.addEncodedQuery('groupLIKEServiceNOW-ITC-RM');
gr.addAggregate('COUNT', 'user');
gr.query();
while (gr.next()) {
var User = gr.user;
var gr1 = GlideRecord('time_sheet');
gr1.addEncodedQuery("week_starts_onONLast week@javascript:gs.beginningOfLastWeek()@javascript:gs.endOfLastWeek()^user=" + User);
gr1.query();
if (!gr1.hasNext()) {
gs.eventQueue('tc.norecord.thisweek', current, parm1, parm2);
}
}
Can anyone please suggest !!!!!!!!!
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-07-2022 11:26 AM
Oh, sorry, I tried them both
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-07-2022 11:36 AM
Hi
please have a look on the following excellent page, which explains how to create events: https://developer.servicenow.com/dev.do#!/learn/courses/sandiego/app_store_learnv2_automatingapps_sa...
Then decide what you want to store at parm1 and parm2. These values then can be used in your email notification - for example, to set the recipient.
Kind regards
Maik