Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Remove Report Schedule in Management Reporter 2012

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:
  • Robert Yao Profile Picture
    Robert Yao 492 on at
    RE: Remove Report Schedule in Management Reporter 2012

    Greg,

    This is the table that I am looking for exactly.

    Thanks,

    Rob

  • Verified answer
    Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Remove Report Schedule in Management Reporter 2012

    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.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans