as you already have the subscription setup, I would remove the schedule from the T-SQL job which is used to run the subscription, then as step 2 of your load from oracle, issue a SP_START_JOB procedure call to run the subscription job.

the script below should help you find the right GUID job name for the report.

SELECT

U.UserName AS SubscriptionOwner,

C.Path AS ReportPath,

CONVERT(XML,S.ExtensionSettings) AS SubscriptionSettings,

S.EventType AS SubscriptionType,

CONVERT(XML,S.Parameters) AS ReportParameters,

S.DeliveryExtension AS DeliveryMethod,

Sc.Name AS ScheduleName,

Rs.ScheduleID

FROM

Subscriptions S

INNER JOIN

Users U

ON

S.OwnerID = U.UserID

INNER JOIN

Catalog C

ON

S.Report_OID = C.ItemID

INNER JOIN

ReportSchedule RS

ON

S.SubscriptionID = RS.SubscriptionID

INNER JOIN

Schedule Sc

ON

RS.ScheduleID = Sc.ScheduleID

ORDER BY

1,2