I need a broken 10 second SQL Script

• krypto69

  SSChampion

  Points: 13604

  More actions

  January 24, 2018 at 6:49 am

  #410098

  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

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  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.

  ---

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 24, 2018 at 7:12 am

  #1977100

  WAITFOR DELAY '00:00:10';
SELECT 1/0;

  Yours fails instantly because the last query throws a parsing error, and the batch is parsed before any part of it starts executing.
  

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• krypto69

  SSChampion

  Points: 13604

  More actions

  January 24, 2018 at 7:26 am

  #1977103

  GilaMonster - Wednesday, January 24, 2018 7:12 AM

  WAITFOR DELAY '00:00:10';
SELECT 1/0;

  Yours fails instantly because the last query throws a parsing error, and the batch is parsed before any part of it starts executing.
  

  Ahh..thanks Gail