Saw this my posting and decided to put the solution that worked for me.

I created the subscription normal and putting an end date to the subscription because it wil now be triggered by the job. Then created a job using the same subscription name so I can track my job easily. Then using the code in the job step.

IF Exists (My SQl Code here which is the same code that I used in the report)

BEGIN

EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData= '08F7299B-ED9A-4F30-A06B-B2A5A8F3D608' -- subscription Id

END

To easily get the subscription Id of my report and all other subscription ids.

I created a report using this code

SELECT name

,subscriptionid

,itemid

,ExtensionSettings

FROM ReportServer.dbo.Subscriptions s

INNER JOIN ReportServer.dbo.[Catalog] c ON c.ItemID = s.Report_OID

WHERE Deliveryextension = 'Report Server Email'

ORDER BY name

Hope this helps someone.

EO