Home Forums Reporting Services Reporting Services 2008/R2 Administration How do you delete old one time subscriptions? RE: How do you delete old one time subscriptions?

  • October 3, 2013 at 8:35 am

    #1655591

    I think i figure it out.

    Delete

    FROM ReportServer.dbo.Subscriptions

    FROM ReportServer.dbo.Subscriptions S

    INNER JOIN ReportServer.dbo.Catalog C

    ON S.Report_OID = C.ItemID

    INNER JOIN ReportServer.dbo.Users U

    ON S.OwnerID = U.UserID

    WHERE path like '/XXXXXX/%' and CreationDate <'10/01/2013'

    If someone has a better solution or suggestion, please reply.

    THanks

    Mike


    Mike