Notifications
Announcements
I am running into an issue in MR2012CU16 which I found it is very difficult to remove report schedule. I don't have problem to create a schedule then remove from the program. I have several schedules created before which I cannot open and getting 'the operation could not be completed because the item no longer exists'. I ran a test to create a new schedule then checked in SQL, found it stored data in [ManagementReporter].[Scheduling].[Task], [ManagementReporter].[Scheduling].[TaskState] & [ManagementReporter].[Scheduling].[Trigger], I ran a sql query to delete the schedule record in the task, the result displayed in query showing it removed record from 7 different tables, I opened MR & found the schedule that I just deleted from the query is still among the list, I found the deleted record is setting in [ManagementReporter].[Scheduling].[TaskDeletionTracking] table. Does anybody know how long it will stay in this table? How am I going to be able to remove other schedule which I even could not be able to open? Does anybody have a script to remove those schedules?
Thanks in advance,
Rob
Hi Robert,
The schedule that you see in Report Designer is held in the Reporting.ControlReportSchedule table. Deleting it from thee should remove it from the front end.
Greg,
This is the table that I am looking for exactly.
Thanks,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 678 Super User 2025 Season 2
André Arnaud de Cal... 407 Super User 2025 Season 2
Martin Dráb 283 Most Valuable Professional