If you want to pause the execution of the code block until a specific time is reached , you can try using the WAITFOR TIME statement in SQL Server.
For example , you want the subsequent statement to execute at 10.10 am , here’s how the WAITFOR TIME can be used.
use AdventureWorks2014
GO
WAITFOR TIME ’10:10:00′;
select * from HumanResources.Department
go