Scheduled job not being trigger email notification

Venkataramudu A
Tera Contributor

‎09-05-2024 11:28 PM

Hello,

 

I have created scheduled job to trigger email notification on Policy exception records where valid_to date is Past Due date. by running scheduled below scheduled job, notifications are not triggering. could you please advise to fix below code.

 

VenkataramuduA_0-1725603721044.png

VenkataramuduA_3-1725604049588.png

 

 

notification:

VenkataramuduA_1-1725603904613.png

VenkataramuduA_2-1725603951558.png

 

 

0 Helpfuls
  • 261 Views
1 REPLY 1

Phil Swann
Tera Guru
Tera Guru

‎09-05-2024 11:30 PM - edited ‎09-05-2024 11:33 PM

Do you actually have any PERs which have expired, and not complete? The workflow should automatically close them after they expire. Validate the result of your query, and make sure you have data. There should be none. 

 

 

var risks is not risks, its pointing to policy exception table 

Regarding the naming conventions, I suggest you fix that as it will help with readability. 

var grPolicyException would be perfect , in the singular 

 

Also, might be a perfect scenario for a scheduled flow rather than scheduled job and avoid coding altogether