integration failure

[ujjwala_678]

Hello Experts,

I am looking for something that will send email to some specific users where is there is no Insert/update of records in the list of tables. table , operations, User to notify and Number of days should be accepted dynamically from a property. Email should should contain a table with the list of tables where there is no interaction in last n number of days. Any thoughts on the implementation part?

All kinds of suggestions are welcome.

Thank you in advance!

[ujjwala_678]

Hi @Anil Lande ,

My concern is how it will track the activity then?.....if there's no insert/update on tables?

and email notification should run on which table?

Thank you

[Anil Lande · Accepted solution]

Create notification on 'Global' table.

For Example,

The script is checking records updated in last 15 days. If any record is created or updated in Last 15 days then your GlideRecord will get return true for hasNext().

That means if any activity happen in last 15 days then GlideRecord will return some records else you can send notification.

[Utkarsha]

Hello @Anil Lande ,

I tried creating scheduled job with the code shared .....but the issue is when i am executing it , email is not getting triggered, Could you please tell me what could be the reason here?

Thank you

[KevinArtis]

I want to ask something. Can I ask here or start my own thread?