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 ,

Please verify if users have the sn_hr_le.case_writer and sn_hr_le.case_reader roles. 

[Pranesh072]

try to run your scheduled job as HR admin or Lifecycle events for enterprise administrator

[Harmeet2Singh]

can you please share the script from where you are triggering notification?

[samadam]

I tried to run as HR Admin, same thing.

var edate = new GlideDate();

edate.addDaysLocalTime(5);

gs.info("In the script" + edate);

var Case = new GlideRecord('sn_hr_le_case');

Case.addQuery('u_effective_date', edate);

Case.query();

while (Case.next()) {

    gs.info("In the while script");

I could not get this statement to print