I have an Sql Job that executes every 5 mins.
The data source A, that feeds table B, that SQL job works on has sporadic nature,
Some time the transaction arrive in sequence sometimes not.
how can I control the SQL Job to wait for 1 mins during the execution,
and what is the side effect,