Not a SQL guy .....

Want to schedule the query to run automatically -> import data to a file and
email me. Using SQL 2005 Express Edition with SQL Management Studio Express.

Advise Please.

Thank you

To run that query automatically entirely from within SQL Server you need the
SQL Server Agent. But SQL Server Agent is not included in SQL Server Express
Edition.
So you will have to create a Windows job that will connect to SQL Server and
execute the statement.
There are a variety of tools you can use.
See How To Schedule Tasks in Windows XP
http://support.microsoft.com/kb/308569
I think PowerShell also has a scheduling system as well.
And the task will probably use sqlcmd or osql to connect to SQL Server and
execute some set of statements. I hope this gets you started.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"WildPacket" <WildPacket (AT) discussions (DOT) microsoft.com> wrote

I second Rick's suggestion of PowerShell. I use it to perform tasks like this
a lot. I have several reports/alerts that I have automated using PowerShell
to issue a SQL query and then send an HTML formatted message.

Look at http://sqlpsx.codeplex.com/ for some cool tools!

"Rick Byham, MSFT" wrote: