tim laqua dot com Thoughts and Code from Tim Laqua

DECLARE @ReportName VARCHAR(255) = 'Report Name'
 
SELECT
      a.PATH
      ,b.SubscriptionID 
      ,b.Description
      ,CAST(b.PARAMETERS AS XML) AS [PARAMETERS]
      ,b.LastRunTime
      ,b.LastStatus
      ,CAST(b.ExtensionSettings AS XML) AS [ExtensionSettings]
FROM ReportServer.dbo.[CATALOG] a
      INNER JOIN ReportServer.dbo.[Subscriptions] b
            ON b.Report_OID = a.ItemID
WHERE a.Name = @ReportName
 
/*
DECLARE 
       @id varchar(260) = ''
      ,@Type VARCHAR(32)                  = 'TimedSubscription'
 
EXEC [ReportServer].dbo.AddEvent @EventType=@Type, @EventData=@id
 
*/