Automatic update queries

[shart00]

See if I can even explain this without getting confused.
One user authorized to be connected to SQL server. They are currently running update queries to update tables in another database that everyone has authorization to use. The problem is that the data on the server is updated constantly and only when the query is ran manually, do the other users see the information. Is there a way to set something up so that the queries will automatically run every 15 or 20min?

 

[HitechUser]

shart00,

One way I would suggest is using the Windows Scheduler to "submit" a job to process a macro then have the macro close the database when done (so it is available to run later). Just set it to run as you need it.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;230575

Let me know...

 

[HitechUser]

shart00,

You may even like this instead..

HAL

http://www22.brinkster.com/accessory/resources/001.shtml

 

[shart00]

Hal,
Can not download, another "security" feature installed by IT.
Seems they want us to do more of our own programing only as long as it consists of using the wizards ...lol...
Thank you anyways it looks as if it would have done the trick.