Unable to access HR Lifecycle Events case table from Scheduled job

[samadam]

I have a scheduled job to trigger notifications on the le_case table. I tried to run job as system admin, myself who has admin access and user that has le_case table read/write access. The job runs but fails to retrieve data even though there is matching data. What can be done to fix this?

[Shraddha Kadam]

Hello @samadam ,

Debug this script. I think the query is not matching, hence your job is not running.

[samadam]

I have matching records. I made sure that.

[Shraddha Kadam · Accepted solution]

Run this script on fix script and see how much count you are getting using the getRowCount() method.

[Community Alums]

Are you creating scheduled job in the same scope as table?

[Vishal Jaswal]

Hello @samadam 

If you can share the scheduled job script and also share if it is a domain separated instance then it will be helpful to understand the complete issue.

You can also achieve the same via flow using Send Notification Action and keep your notification Send When Triggered.