Next Run DateTime for SSRS Subscriptions

USE ReportServer
 
SELECT
  C.Name AS ReportName
  ,CASE 
  	WHEN NEXT_RUN_DATE > 0 
				THEN DATEADD(N,(NEXT_RUN_TIME%10000)/100
            ,DATEADD(HH,NEXT_RUN_TIME/10000
            ,CONVERT(DATETIME,CONVERT(VARCHAR(8),NEXT_RUN_DATE),112)))  
		ELSE CONVERT(DATETIME,CONVERT(VARCHAR(8),'19000101'),112) 
	END 'Next Run Date'
	,[LastStatus]
	,[DeliveryExtension]
FROM dbo.[Catalog] C (NOLOCK)
	INNER JOIN dbo.[Subscriptions] S (NOLOCK) ON (C.ItemID = S.Report_OID)
	INNER JOIN dbo.ReportSchedule R (NOLOCK) ON (S.SubscriptionID = R.SubscriptionID)
	INNER JOIN msdb.dbo.sysjobs J (NOLOCK) ON (Convert(nvarchar(128),R.ScheduleID) = J.name)
	INNER JOIN msdb.dbo.sysjobschedules JS (NOLOCK) ON (J.job_id = JS.job_id)
ORDER BY 2,1