A union of curiosity and data science

Knowledgebase and brain dump of a database engineer


SQL Jobs for SSRS Subscriptions are made with a GUID as the name . Find the actual report.

The GUID within the Job is a nightmare, use the following query to find the guid for a SQL Server Reporting Server Report Subscription .
 
 
 

SELECT a.ScheduleID

, c.name

FROM ReportServer.dbo.ReportSchedule a

join ReportServer.dbo.Catalog c on c.ItemID = a.ReportID

where c.name = 'Report Name'

 

 
 
 
Of course there's always the option to open up these jobs copy the SQL and create your own scheduled task for running the Subscription. 
 
 
 

Comments (2) -

  • ddewdCSe

    4/17/2025 7:16:05 AM | Reply

    490688 511864I�d should talk with you here. Which is not some thing I do! I spend time reading an write-up that could get individuals to feel. Also, appreciate your allowing me to comment! 801238

Add comment