<div>
You can create sql agent job and set notifications to send email.<br />
schedule the job.
</div>


You can create sql agent job and set notifications to send email.
schedule the job.

<div>
Steps:<br />
1. Right click on Sql Agent and create new job<br />
2. Create step.<br />
3. Paste the query in the corresponding textbox.<br />
4. Select schedule the job and set the schedule settings<br />
5. Click notifications and set the options. Email -&gt; if job fails bla bla
</div>


Steps:
1. Right click on Sql Agent and create new job
2. Create step.
3. Paste the query in the corresponding textbox.
4. Select schedule the job and set the schedule settings
5. Click notifications and set the options. Email -> if job fails bla bla

<div>
Thank you rajvja. &nbsp;I am trying this now.<br />
It looks like my option to email the results is grayed out.. so I am checking to see why.<br />

</div>


Thank you rajvja.  I am trying this now.
It looks like my option to email the results is grayed out.. so I am checking to see why.


<div>
SQLTriVegg,<br />
Yes, it looks like even though SQL Server Agent can execute a SQL command, &nbsp;it doesn't provide a vehicle for emailing the actual results to a recipient. &nbsp;Liek you said, the &quot;notifications&quot; are referring to the job outcome... whether it was a success or failure.<br />
<br />
Thanks for the tip.<br />

</div>


SQLTriVegg,
Yes, it looks like even though SQL Server Agent can execute a SQL command,  it doesn't provide a vehicle for emailing the actual results to a recipient.  Liek you said, the "notifications" are referring to the job outcome... whether it was a success or failure.

Thanks for the tip.


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
I have to run a query every morning and email the results to a few people. &nbsp;Is there a way to automate this? &nbsp;I am using SQL Server Management Studio in SQL Serve 2005.<br />
<br />
The steps are:<br />
1- Open query<br />
2 - execute query<br />
3 - export results to a file (or copy/paste results to email body)<br />
4 - email recipients<br />
<br />
Thanks!!<br />

</div>
</div>


Hello Experts,
I have to run a query every morning and email the results to a few people.  Is there a way to automate this?  I am using SQL Server Management Studio in SQL Serve 2005.

The steps are:
1- Open query
2 - execute query
3 - export results to a file (or copy/paste results to email body)
4 - email recipients

Thanks!!


*** How to Schedule, Execute, and Export a SQL statement in SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.