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
Author
Message
Posted Thursday, June 26, 2014 1:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:18 AM
Points: 90, Visits: 135
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 1,826, Visits: 1,359
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.
SELECT * 
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