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)
EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData= '08F7299B-ED9A-4F30-A06B-B2A5A8F3D608' -- subscription Id
To easily get the subscription Id of my report and all other subscription ids.
I created a report using this code
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.