scheduled script i not executing

[Priti18]

hi

I have one scheduled script which sends some kind of report every day but i dont know whats wrong that even though am using execute now ui button it  is not doing anything.

I used log in the first line of my code still not sure  what's the issue?

[Priti18]

i tried and one thing which i noticed that it stays in ready state for more than hr also once it is out of events table i get this in logs

Invalid query detected, please check logs for details [Unknown field action_run_at in table sys_script]

[Jaspal Singh]

Could find one HI Article.

Kindly give it a check. Also, sys_script is Business Rule table & there does not exists any field action_run_at in the table.

[Priti18]

it works through bg script then why not from scheduled script and its a working script i have tested also what happened suddenly

[Ankur Bawiskar · Accepted solution]

Hi Priti,

Refer this article; it talks on same thing

Backlog of jobs in sys_trigger with State: Ready that are not picked up to be processed though there...

If this is for client instance raise HI ticket with ServiceNow

Regards
Ankur