Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to identify report server jobs Expand / Collapse
Posted Thursday, June 26, 2014 1:18 AM


Group: General Forum Members
Last Login: Thursday, September 24, 2015 7:16 AM
Points: 108, Visits: 154
Hi we have various report server jobs schedule on our sql server.I can determine what are this jobs doing as they donot have name numbers.

Is there any way to determine what report sever jobs are doing.

Is there any way to query sql server report database to gathere information about this report server jobs
Post #1586254
Posted Friday, June 27, 2014 10:12 AM



Group: General Forum Members
Last Login: Friday, November 20, 2015 1:28 PM
Points: 2,194, Visits: 1,641
You can pick and choose columns from it. From here you can see the Report name as well as the job name so you can tie the two back together. Not sure if this is what you need though.
FROM ReportServer..Catalog cat
INNER JOIN ReportServer..Subscriptions sub on cat.ItemID = sub.Report_OID
INNER JOIN ReportServer..ReportSchedule rs on cat.ItemID = rs.ReportID
and sub.SubscriptionID = rs.SubscriptionID

Everything is awesome!
Post #1586946
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse