Viewing 2 posts - 1 through 2 (of 2 total)
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...
March 10, 2015 at 4:05 am
#1782823
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) =...
September 26, 2014 at 6:27 am
#1748462