Poster has probably fixed his problem by now, but since I ran into the same issue today and didn't find a solution searching the internet, I'll share mine: the scalar...

You say that you want a load to either succeed or roll back to the previous day. Wouldn't it be a work-around to:

1. create a new database

2. load your data...

Make the alert, in the tab response choose 'New job', make the job, executing the following script:

DECLARE @subject AS varchar(100) = 'Transaction longer than 60 seconds'

DECLARE @message AS varchar(130) =...