how to impletment sql job using sp_procoption with out waitfor delay.

• rajemessage 14195

  Hall of Fame

  Points: 3299

  More actions

  April 15, 2014 at 7:19 am

  #292446

  HI,

  I have sheduled following store proc in masters USING sp_procoption, as i do not have sqlagent.

  q1) Can it be implemented without "waitfor delay" using some time or some better method.

  q2) Is there any proble m with following code , with respect to "waitfor delay".

  ALTER

  PROCEDURE uspStartProc

  AS

  BEGIN

  START_AGAIN:

  WAITFOR DELAY '00:00:10'

  IF EXISTS(SELECT * FROM DBABC.dbo.TABLE1 WHERE Status=1)

  BEGIN

  EXEC IRP2_DBABC.dbo.uspABC END

  -- PRINT CONVERT(VARCHAR(23), GETDATE(), 126)

  GOTO START_AGAIN

  END