Home Forums Reporting Services Reporting Services Can anyone explain why the following schedule for a timed subscription ran on the first of February RE: Can anyone explain why the following schedule for a timed subscription ran on the first of February

  • Gazareth (2/4/2015)


    Bear in mind you'll only be able to see your own subscriptions on that report, those created by other logins won't show.

    Edit: I'm talking rubbish if you're looking in the report's own subscriptions page.

    This might help you identify what's running it:

    USE ReportServer

    GO

    SELECT c.Name AS Report, c.Path, s.Name AS ScheduleName, sub.Description AS ScheduleDescription, sub.LastRunTime

    FROM dbo.Catalog c

    INNER JOIN dbo.ReportSchedule rs ON rs.ReportID = c.ItemID

    INNER JOIN dbo.Schedule s ON s.ScheduleID = rs.ScheduleID

    INNER JOIN dbo.Subscriptions sub ON sub.SubscriptionID = rs.SubscriptionID

    WHERE c.Name = 'Report Name'

    I'm looking via the manage subscriptions,since I don't have any subscriptions on that report (I only created the subscription)

    I've executed that code,see the result below (sensitive info has been blanked out), I've included the history as well (or lack there off)