Thanks again alzdba

Ok, my boss can be quite quarrelsome. So, you would agree that what we have come up with is a good enough...

sorry, forgot the rollback TRAN and should be @@Error not @Error.

BEGIN TRAN

--run some intermediate/agregate table transaction

IF @@ERROR=0

    BEGIN

    COMMIT TRAN

    update T_TableLoadData

    set timestamp_last_update = getdate()

    where Table_Name = 'Mytable'

    if...

Thanks, in this case we are using LEI to just hold some SQL and run them daily, 1 job for each datawarehouse table insert/update.

OK, I could use what you have...