Using WAITFOR TIME

[boboleft]

Does anybody know with the waitfor time statement, do I still need to hit F5 to execute the query or will the query automatically execute at 10:20 as long as I keep my query analyzer open??

WAITFOR TIME '22:20';
EXECUTE sp_update_job @job_name = 'TestJob',

 

[mrdenny]

You will need to run the query. The WAITFOR TIME statement is executed by the engine, not by the client.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[boboleft]

thanks for the response.