Query next run schedule for all reports

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Query next run schedule for all reports

Author

Topic

phoeneous
Starting Member

9 Posts

Posted - 2009-10-19 : 13:34:55

Im trying to query the next run schedule for all of my reports in SSRS. I am able to query LastStatus and LastRunTime but I dont know where to find the full schedule details of the report. This is what I have so far;

SELECT Catalog.Name, Subscriptions.LastStatus, Subscriptions.LastRunTime, Subscriptions.Description AS Expr1
FROM Catalog INNER JOIN
Subscriptions ON Catalog.ItemID = Subscriptions.Report_OID

I am unable to link the Schedules table either...

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-19 : 15:01:00

I don't think there is a "Next_Run_DateTime" field exactly but I do know it is embedded in the column MatchData on table subscriptions. Look for the tag <StartDateTime xmlns="http://schemas.microsoft.com/sqlserver/2006/03/15/reporting/reportingservices">
Then the date time to start:
2009-10-19T14:40:00.000-04:00

And finally the end tag:
</StartDateTime>

John

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources