Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Yesterday @ 8:59 AM
Points: 109, Visits: 155
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, December 2, 2016 1:54 PM
Points: 2,212, Visits: 1,688
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