SQL Server Reporting Service’te Schedule Edilen Raporlarınızı Nasıl Bulabilirsiniz?

SQL Server Reporting Service’te Schedule Edilen Raporlarınızı aşağıdaki SQL sorgusu yardımı ile bulabilirsiniz.

SELECT 
    sub.SubscriptionID,
    sub.Description AS SubscriptionDescription,
    sub.LastStatus,
    sub.LastRunTime,
    sub.EventType,
    sub.DeliveryExtension,
    sub.InactiveFlags,
    c.ItemID,
    c.Path AS ReportPath,
    c.Name AS ReportName,
    s.ScheduleID,
    sch.ScheduleID AS AgentScheduleID,
    sch.Name AS ScheduleName,
    sch.StartDate,
    sch.LastRunTime AS ScheduleLastRun,
    u.UserName AS CreatedBy,
    sub.ModifiedDate
FROM ReportServer.dbo.Subscriptions sub
    INNER JOIN ReportServer.dbo.Catalog c 
        ON sub.Report_OID = c.ItemID
    LEFT JOIN ReportServer.dbo.Users u 
        ON u.UserID = sub.OwnerID
    LEFT JOIN ReportServer.dbo.ReportSchedule s 
        ON sub.SubscriptionID = s.SubscriptionID
    LEFT JOIN ReportServer.dbo.Schedule sch 
        ON s.ScheduleID = sch.ScheduleID
ORDER BY c.Path, sub.Description;