List SSRS Subscriptions

SELECT 
	c.Name,
	s.StartDate,
	s.NextRunTime,
	s.LastRunTime,
	s.EndDate,
	s.RecurrenceType,
	s.LastRunStatus,
	s.MinutesInterval,
	s.DaysInterval,
	s.WeeksInterval,
	s.DaysOfWeek,
	s.DaysOfMonth,
	s.[Month],
	s.MonthlyWeek
FROM 
	dbo.catalog c with (nolock)
	INNER JOIN dbo.ReportSchedule rs ON rs.ReportID = c.ItemID
	INNER JOIN dbo.Schedule s with (nolock)	ON rs.ScheduleID = s.ScheduleID
order BY 
	c.name