Simple T-SQL implementation for running SSRS subscriptions.

CREATE PROCEDURE [dbo].[SR_RunSubscriptions]
         @Pattern varchar(max)
AS
BEGIN
       SET NOCOUNT ON;
       SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
       DECLARE @SubscriptionID nvarchar(max);
       DECLARE DbcurSQL CURSOR FOR
              (
             SELECT SubscriptionID FROM
             [ReportServer].dbo.[Subscriptions]
             WHERE [Description] LIKE @Pattern
              );
       OPEN DbcurSQL;
       FETCH NEXT FROM DbcurSQL INTO @SubscriptionID;
       WHILE @@FETCH_STATUS = 0
            BEGIN
                EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription',@EventData=@SubscriptionID;
                FETCH NEXT FROM DbcurSQL INTO @SubscriptionID;
            END;
       CLOSE DbcurSQL;
       DEALLOCATE DbcurSQL;
END