Sqlserverwaitfortime delay function usage

The SQL statement WaitFor can be written to a stored procedure and executed again: waitFor {Delaytime | Timetime} the Time after Delay is the Delay Time. The Time after the execution Time is the specified execution Time. The formula is HH: MM: SS. The date example is not supported: ------ specify to execute Beginwaitfortime10: 00se

The SQL statement WaitFor can be written to a stored procedure and executed again: waitFor {Delay 'time' | time' time} the Time after Delay is the Delay time. The Time after the execution time is the specified Time. The formula is HH: MM: SS, the following is an example of a date not supported: ------ Begin waitfor time '10: 00' se is executed.

The SQL statement WaitFor can be written to a stored procedure and executed again.

Syntax: WaitFor {Delay 'time' | time' time}

The time after Delay is the Delay time for execution.

The Time after Time is the specified execution Time in the format of "HH: MM: SS". The date is not supported.

Example:

------ Specify for execution

Begin

Waitfor time '10: 00'

Select * from tablename

End

----- Specify to wait 1 hour before execution

Begin

Waitfor delay '1: 00'

Select * from tablename

End

Dbms_lock.sleep (n) is paused for n seconds and then executed

Generally, this package is created, but the permission is not granted by default. Another important step is to grant the user the all on dbms_lock permission ..

As a DBA

Grant execute on dbms_lock to USERNAME;

Stored in the storage process

1. WAITFOR

-- WAITFOR

-- For example, the SELECT statement is executed after 1 hour, 2 minutes, and 3 seconds.

Waitfor delay '01: 02: 03'

Select * from employee

-- For example, the SELECT statement will not be executed until PM.

Waitfor time '23: 08: 00'

Select * from employee