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