I replaced the select with a delete, it is not working.

delete

C.Name

,C.Path

,U.UserName

,S.InactiveFlags

,C.CreationDate

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'

Any helps appreciated.

Mike