Page 1 of 1
Broken report sending constant emails
Posted: Thu Mar 26, 2020 10:29 am
by snapon_admin
One of my coworkers created a scheduled report (State History) and did something wrong so that he started getting emails every 5 minutes or so. He deleted the report to try and fix the issue but is still getting the emails, and has gotten about 980 since yesterday. How do I stop the emails coming in when there's no longer a report to remove?
Re: Broken report sending constant emails
Posted: Thu Mar 26, 2020 3:52 pm
by lmiltchev
I wonder if the report was not actually removed from cron for some reason, even though it is not visible in the GUI... You can run the following command from the command line to see all of the scheduled reports:
You can check the usernames to see if this user's report is still scheduled.
Is it possible that the report was copied to a different user? Perhaps, the "original" user deleted it, but the report is sent by someone else?
If you find the offending line in the crontab, you can remove it by editing the file:
Hope this helps.
Re: Broken report sending constant emails
Posted: Thu Mar 26, 2020 4:02 pm
by snapon_admin
How do I edit that file? Sorry, not super familiar with cron.
Re: Broken report sending constant emails
Posted: Thu Mar 26, 2020 4:14 pm
by lmiltchev
When you open the file by running:
it should open in the "default" text editor. Most probably, this is going to be "vi".
Go up/down using the arrows on the keyboard. When the cursor lines up with the line that you would like to delete, hit the "d" button on the keyboard twice. The line should be gone now. To save changes, and exit, type:
and hit "Enter".
Did you find the report that you need to remove?
Note: Keep in mind that if the report was not deleted from the GUI, it would still show up in the web UI, even though it would not run.