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