Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Deon Smit
Starting Member
47 Posts |
 Posted - 2008-06-17 : 04:49:03
|
| HiI want to loop this command with a pause. It must run every 30 min to refresh my query. Can anyone assist me. select * from BULKPICKXLOCThanks |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2008-06-17 : 04:52:20
|
| You can schedule your query to run after every 30 mins.. using the SQL Jobs. look for more details on book online now how to create the jobChiraghttp://www.chirikworld.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-17 : 04:53:08
|
| if you want this to be executed every 30 min then create a job to call this and give frequency of job to be 30 mins with start and end time. |
|
|
|
Deon Smit
Starting Member
47 Posts |
Posted - 2008-06-17 : 05:21:28
|
quote:
Originally posted by visakh16
if you want this to be executed every 30 min then create a job to call this and give frequency of job to be 30 mins with start and end time.
How can I explain this. I got a screen in the warehouse that Pickers look at the QTY that is being picked. The Query result is displayed on it and we have to just rerun the query every 30 min. If i schedule a job. Where will the results be displayed? I just want to leave the query running allday. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-17 : 05:52:46
|
quote:
Originally posted by Deon Smit
quote:
Originally posted by visakh16
if you want this to be executed every 30 min then create a job to call this and give frequency of job to be 30 mins with start and end time.
How can I explain this. I got a screen in the warehouse that Pickers look at the QTY that is being picked. The Query result is displayed on it and we have to just rerun the query every 30 min. If i schedule a job. Where will the results be displayed? I just want to leave the query running allday.
You could populate the results of query to a table each time and let you screen take the results from this table. |
|
|
|
|
|
|
Loop