select
    'EXEC dbo.AddEvent @EventType=''TimedSubscription'', @EventData=''' + CAST(a.SubscriptionID AS VARCHAR(40)) + '''' AS ReportCommand
    , b.name AS JobName
    , a.SubscriptionID
    , e.name
    , e.path
    , d.description
    , laststatus
    , eventtype
    , LastRunTime