Thanks Anita for descriptive response But I have already used this approach and there is limitation in my case with this approach is that ,It will stop the transition at delivery only But I need transition to call the reporting workflow that is extarcting data from Recipient exclusion logs table and ACX datasource details insert specific to each file.Have you ever used this "Test SMTP Delivery" feature of Delivery properties as It is stopping the execution But there will not be any log that will...

Thanks Dom, This I have to do because our business users want a reporting done before Going for Delivery execution for Additional typologies based on DB data.