Scheduled reports sending even though schedule is inactive

[conanlloyd]

Our sub-prod environments, (dev, test, and sandbox) are all set to send all emails to a specific email box to allow us to troubleshot notifications and share demos when needed.

As part of our clone down process, we now deactivate all scheduled emailing of reports through script, marking all of the entries in the sysauto_report table as inactive.  The assumption was that this would stop all emailing of scheduled reports in our sub-prod environments.

However, we have noticed that the reports are still being sent based on the schedules.  Today for instance 41 emails were sent for scheduled reports that all are inactive in the sysauto_report table.

How/where can I shut them off?

[Ankur Bawiskar]

Hi,

I don't think turning reports as inactive stops scheduled reports.

you can inactivate the scheduled reports as well

Regards
Ankur

[Ankur Bawiskar]

@conanlloyd 

Did you get a chance to check on my above response?

Regards
Ankur

[Aman Kumar S · Accepted solution]

Hey,

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

[Axel5]

Thank you Aman.