New SQL Administrator

[Sedg]

I would like to automate this process:

I have a query built in Query analizer.
I need to run it everyday at a certain time.
I need the result set moved to a location folder on the network or emailed
in house (exchange server) to an employee.

NT 4 network (large), SQL 7

Any advice is very much appreciated I am trying to learn as much as possible
in a very short time.
Any practical web-sites on SQL server welcome also

Thankyou.

[norther...@my-deja.com]

--Assuming SQL 7.0

Use SQL Server Agent to schedule the job on a regular basis. As part
of the job step you can specify the output location.

To e-mail the results you have to invoke the xp_sendmail extended
stored procedure. You could e-mail the result set as an attachment.
See Books Online for details on xp_sendmail. Assuming that SQL Mail is
started (under EM/Support Services).

For web sites, try SQLServerCentral.com or SQL-Server-Performance.Com

Hope this helps!

In article <3a41780a$1...@whooshnet.com>,

Sent via Deja.com
http://www.deja.com/

[Hong Zeng]

Check Books on Line and look for xp_sendmail or write a batch file which run
the query and redirect the result to a file.

Sedg <se...@whooshnet.com> wrote in message
news:3a41780a$1...@whooshnet.com...