web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Remove Report Schedule in Management Reporter 2012

(0) ShareShare
ReportReport
Posted on by 492

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

Categories:
I have the same question (0)
  • Verified answer
    Greg Byer Profile Picture
    2,586 on at

    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.

  • Robert Yao Profile Picture
    492 on at

    Greg,

    This is the table that I am looking for exactly.

    Thanks,

    Rob

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.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 678 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 407 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 283 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans