Automating Queries 1

[Jamie2002]

I'm very new to SQL so please forgive my ignorance.

Briefly how do you go about making standard queries run at specified dates, so that you can schedule figures to run overnight.

We're taking very simple select queries that return a view that is then saved as text and used in excel and Access.

Thanks for your patience.

 

[RickCole]

You can set up scheduled jobs from within SQL Server Agent, which can be administered from with Enterprise manager.

Look in BOL under the topic "Defining Jobs". This should be enough to get you started.

Rick.

 

[Jamie2002]

BOL ?

I told you I did'nt know much.

Thanks in advance.

 

[RickCole]

BOL stands for Books On Line and should be installed along with the client tools for SQL Server on your PC.

Basically it's the full Microsoft documentation for SQL Server. I would suggest you familiarise yourself with BOL as it's something you will need to use quite frequently.

Rick.

 

[SQLBill]

There's two ways (that I know of) to get to the BOL. Start > Programs > Microsoft SQL Server > Books Online OR In Enterprise Manager, on the console tree, right-click on your database and select Help.

-Bill

 

[tlbroadbent]

See faq183-689 about SQL BOL. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm