Reporting services question, urgent please!!

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)

Reporting services question, urgent please!!

Author

Topic

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2009-02-09 : 12:42:37

Hi, I am trying to find all the active subscriptions we have in our reportserver database. I want to know the reportname, and what time it's scheduled to run. I am using InactiveFlags = 0 to pull all the active subscriptions.
So far, I am able to write the following query, please let me know what I should do to get the desired info.

SELECT Report_OID, LastRunTime, SubscriptionID, *
FROM Subscriptions
WHERE InactiveFlags = 0 --to pull active subscriptions
ORDER BY LastRunTime desc

Please advice.

Thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-09 : 17:27:45

[code]SELECT EL.UserName, EL.Format, EL.TimeStart, cat.Name, EL.Parameters,
CONVERT(nvarchar(10), EL.TimeStart, 101) AS rundate
FROM ELecutionLog AS EL INNER JOIN
Catalog AS cat ON EL.ReportID = cat.ItemID
ORDER BY EL.TimeStart DESC[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources