Home Forums SQL Server 2017 SQL Server 2017 - Development I need a broken 10 second SQL Script RE: I need a broken 10 second SQL Script

  • January 24, 2018 at 7:06 am

    #1977097

    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

    Try putting a 'GO' after your WAITFOR DELAY.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.