I have a stored procedure provided in the code snippet. When I run it in my ActiveXScript in my DTS:
oConn.Execute = "[SDI].dbo.spDelay '0:1:0'"
While testing it, it works fine when the delay is set to 35 seconds: oConn.Execute = "[SDI].dbo.spDelay '0:0:35'"
But if I put 50 seconds or a minute as provided above, I get an error:
[Microsoft][ODBC SQL Server Driver] TimeOut Expired
I have gone to server --> Properties --> Connections --> and set Query timeout to 0 seconds but I still get the error.
The ActiveXScript sends emails to records in a table, I want the DTS to pause for a minute or 2 in between emails.
CREATE PROCEDURE spDelay (@interval CHAR(9))
WAITFOR DELAY @interval