Broken report sending constant emails

[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?

[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:

Code: Select all

crontab -u apache -l

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:

Code: Select all

crontab -u apache -e

Hope this helps.

[snapon_admin]

How do I edit that file? Sorry, not super familiar with cron.

[lmiltchev]

When you open the file by running:

Code: Select all

crontab -u apache -e

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:

Code: Select all

:wq

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.