22
Hello,
I am trying to clear the Mangament Reporter report queue with the following query.
USE ManagementReporter
DELETE FROM Repository WHERE STATUSTYPE<>'0'
And am getting the following error;
Msg 208, Level 16, State 1, Line 2
Invalid object name 'Repository'
How can I correct this to clear the queue ?
Thank you.
Bob Morris
Hi Bob,
You can use the queries below to remove reports from the Report Queue:
select * from Reporting.Repository where StatusType in (1, 2, 10, 30, 40)
That will show you any report that has a status of failed (1), canceled (2), queued(10), cancelling(30), or queuing(40).
Depending on the status type you want to remove from the queue, you can use the same statement as before:
delete from Reporting.Repository where StatusType = x
delete Reporting.RepositoryMessage
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,570
Super User 2024 Season 2
#2
Martin Dráb
228,683
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
