Scheduled reports sending even though active is false

[Amina El hadad]

Emails were sent for scheduled reports even if I deactivate the scheduled reports from the 'sysauto_report' table.

Also I noticed that the same scheduled reports are active in scheduled export table. 

Should I deactivate them from both tables? 

[Dr Atul G- LNG]

Yes, the technical deactivate  on both tables @Amina El hadad 

[Amina El hadad]

Thank you @Dr Atul G- LNG for your reply. This behavior was introduced with the Zurich version, right?

[Dr Atul G- LNG]

This is an known issue for scheduled jobs and applicable for scheduled report as well

Description

Schedule  job deactivate but schedule still getting created.

Cause

sys_trigger record is set to run Daily and that's why it keeps running the job.

Resolution

Please delete the deactivated record in the sys_trigger table
https://xxx.service-now.com/nav_to.do?uri=sys_trigger.do?sys_id=xxx 

Ref link:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0855616

[Tanushree Maiti]

Hi @Amina El hadad 

Refer this link for solution : https://www.servicenow.com/community/developer-forum/scheduled-reports-sending-even-though-schedule-...