Scheduled Report Management
Hi,
Is there a way to view and edit scheduled Axiom reports , and the details of the chart/application and the user?
I have many errors in the logs, all presumably from scheduled reports created by users that have since resigned and comprehensively removed from Active Directory.
I have seen some details in a SQLite file, but I don't want to scratch where I don't belong.
Regards,
Deon
1 reply
-
Hi ,
You can use the ID from the message you're displaying to remove any reports you no longer wish to run. I've tried this on my system and it seems to have work. You may want to create a backup of the SQLite just in case. I had to remove it from 3 of the tables:
- QRTZ_CRON_TRIGGERS
- QRTZ_JOB_DETAILS
- QRTZ_TRIGGERS
You should see the corresponding ID in the TRIGGER NAME or JOB NAME column within those tables. I would stop the Axiom service before editing the file.
I had to run DB Browser as an admin in order to remove the records. I also noticed it would not let me remove the records from the QRTZ_JOB_DETAILS until I removed them from the other 2 tables and saved it.
Once you remove the records from each of the 3 tables, Write Changes, then restart Axiom. I did not encounter any errors, even when the report was originally scheduled to run.
Let me know how it goes.