Just a thought... I don't see this functionality built into subscriptions, but there is a reporting services database with a table called 'subscriptions'. It has last execution time and status. I suppose you could put your trigger there... I haven't done this myself, but...