P
Priya Bange
Guest
Hi Experts,
I have data table like below inside SQL Server. I need to run them on other SQL_Instance independently for the listed execute_count with a wait for delay of 5 sec per execution with in its own session. Let say all 3 query will run in its dedicated/shared connection whatever helps to achieve it.
Query 1 -- > Execute 25 times --> wait for delay 5 second after every execution
Query 2 -- > Execute 15 times --> wait for delay 5 second after every execution
Query 3 -- > Execute 20 times --> wait for delay 5 second after every execution
SQL_Query Execute_Count SQL_Instance
Insert into table1
Insert into table2
Insert into table 3
The count of SQL_Query request can increase/decrease but it need to run independently not executing in sequence and wait for each query to meet respective execute_count. Please help , as how to achieve this requirement.
Thanks
Priya
Continue reading...
I have data table like below inside SQL Server. I need to run them on other SQL_Instance independently for the listed execute_count with a wait for delay of 5 sec per execution with in its own session. Let say all 3 query will run in its dedicated/shared connection whatever helps to achieve it.
Query 1 -- > Execute 25 times --> wait for delay 5 second after every execution
Query 2 -- > Execute 15 times --> wait for delay 5 second after every execution
Query 3 -- > Execute 20 times --> wait for delay 5 second after every execution
SQL_Query Execute_Count SQL_Instance
Insert into table1
25
LocalHostInsert into table2
15
LocalHostInsert into table 3
20
LocalHostThe count of SQL_Query request can increase/decrease but it need to run independently not executing in sequence and wait for each query to meet respective execute_count. Please help , as how to achieve this requirement.
Thanks
Priya
Continue reading...