You will have to use the first query in this blog post to find out what job corresponds with which report.
http://www.mssqltips.com/sqlservertip/1846/how-to-easily-identify-a-scheduled-sql-server-reporting-services-report/ Brandon Ryan ClearPointe From: [email protected] [mailto:[email protected]] On Behalf Of Orlebeck, Geoffrey Sent: Thursday, May 28, 2015 12:31 PM To: '[email protected]' Subject: RE: [msmom] Monitoring SSRS Subscription: They are, but each subscription is a GUID string that I haven’t been able to tie back to the actual SSRS subscription they want monitored. So, for example, we may have SQL Job “349173E9-2CF5-429A-C65B-685D5C76FD7E”, but there’s information to tell me that is “Department Attendance Report”. So I’m not sure how to monitor this individual subscription. Thanks, Geoff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Kevin Holman Sent: Thursday, May 28, 2015 9:38 AM To: [email protected]<mailto:[email protected]> Subject: RE: [msmom] Monitoring SSRS Subscription: Aren't all ssrs subscriptions a SQL agent job? ________________________________ From: Orlebeck, Geoffrey<mailto:[email protected]> Sent: 5/28/2015 11:15 AM To: [email protected]<mailto:[email protected]> Subject: [msmom] Monitoring SSRS Subscription: I’ve been trying to do some web searching but haven’t found anything of substance. We have an SSRS report that gathers some data and emails out the report. The report sometimes fails to email and the report writer is wondering if there is a way for SCOM to monitor for that. I checked the Event Log on the server and tried looking in the ReportServerService log files. However, I thought I would ask if anyone here is monitoring actual SSRS subscriptions via SCOM. We are running SCOM 2012 and SSRS is from SQL 2008 R2. Thanks. Confidentiality Notice: This is a transmission from Community Hospital of the Monterey Peninsula. This message and any attached documents may be confidential and contain information protected by state and federal medical privacy statutes. They are intended only for the use of the addressee. If you are not the intended recipient, any disclosure, copying, or distribution of this information is strictly prohibited. If you received this transmission in error, please accept our apologies and notify the sender. Thank you. Confidentiality Notice: This is a transmission from Community Hospital of the Monterey Peninsula. This message and any attached documents may be confidential and contain information protected by state and federal medical privacy statutes. They are intended only for the use of the addressee. If you are not the intended recipient, any disclosure, copying, or distribution of this information is strictly prohibited. If you received this transmission in error, please accept our apologies and notify the sender. Thank you.
