How to set a time to run a query?

[yoritomo]

I have a query that I want to run at about 10pm every night (when everyone has gone home) , to make it even more complicated it queries from sage and creates a table each night (that i want to overwrite the old table) and it will need to enter in the sage login information

Does anyone know how to do this as to be honest, it has me at a bit of a loose end, I guess it would be a macro, but I have no idea of the commands used

 

[freakazeud]

Hi,
why double posting this?
You could create a macro which executes your query and then call this macro with the windows scheduler at whatever time you want. Check this for more: http://support.microsoft.com/?kbid=230575

HTH
Good luck

 

[yoritomo]

Yeah our server was being abit slow and timed out, so I re-did it and it turned into a double post, so I deleted the other ones, hmm thanks, I'll give that a go

 

[freakazeud]

You're welcome.
Glad I could assist.
Good luck on future projects!