Does anyone have any experience with Reporting Services and the EventLog table? I have created a trigger to catch errors when a subscription fails, but I cannot find a way to associate the event from the EventLog table to the Subscriptions table to determine which subscription failed. In the event log there is an execution ID but I am not sure if there is a way to use that to identify the subscription.

Thanks,

PS:I am on SSRS 2008 btw.