krypto69 - Wednesday, January 24, 2018 6:49 AM

Hi,

I am doing some Q/A work where I am executing a ob that I need to fail - after 10 seconds.

I am running this and it does fail - but it fails in one second:

WAITFOR DELAY '00:00:10'

select top (100) * from sysjobs
WAITFOR DELAY '00:00:10'

select blah

Any ideas