E-Mailing stored procedure results of job (SQL Server 2005)

On Aug 22, 11:15 am, J....TakeThisOut@GoldSaucer.Com wrote:
> On Aug 22, 11:09 am, Zamdrist wrote:
>
> > What would be the preferred method of e-mailing the results of a
> > stored procedure ran via a scheduled job? The results would be sent to
> > myself, doesn't have to be fancy or anything.
>
> > I have the procedure, I can create the job...anything pointers would
> > be appreciated. Thank you.
>
> > Steve
>
> Steve,
>
> Under Sql Server Agent --> Jobs --> Right click on the job and
> select properties.
>
> On the notifications tab, you can elect to email the results of the
> job.



If you need to email data generated by the stored procedure, one
method is to have the Procedure create a temporary table, then use
XP_Sendmail to mail that table to yourself.


Exec master..XP_Sendmail @Recipients = 'YourEmail@You.Com',
@Subject = 'Results of Stored Procedure SPNAME'
, @query = 'Select Information from #TTable'
 >> Stay informed about: E-Mailing stored procedure results of job (SQL Server 2005) 

On Aug 22, 9:09 am, Zamdrist wrote:
> What would be the preferred method of e-mailing the results of a
> stored procedure ran via a scheduled job? The results would be sent to
> myself, doesn't have to be fancy or anything.
>
> I have the procedure, I can create the job...anything pointers would
> be appreciated. Thank you.
>
> Steve

I should clarify...I need the result set returned by the procedure,
and not just success/failure of the job. Thanks.
 >> Stay informed about: E-Mailing stored procedure results of job (SQL Server 2005) 

On Aug 22, 9:18 am, J....DeleteThis@GoldSaucer.Com wrote:
> On Aug 22, 11:15 am, J....DeleteThis@GoldSaucer.Com wrote:
>
>
>
> > On Aug 22, 11:09 am, Zamdrist wrote:
>
> > > What would be the preferred method of e-mailing the results of a
> > > stored procedure ran via a scheduled job? The results would be sent to
> > > myself, doesn't have to be fancy or anything.
>
> > > I have the procedure, I can create the job...anything pointers would
> > > be appreciated. Thank you.
>
> > > Steve
>
> > Steve,
>
> > Under Sql Server Agent --> Jobs --> Right click on the job and
> > select properties.
>
> > On the notifications tab, you can elect to email the results of the
> > job.
>
> If you need to email data generated by the stored procedure, one
> method is to have the Procedure create a temporary table, then use
> XP_Sendmail to mail that table to yourself.
>
> Exec master..XP_Sendmail @Recipients = 'YourEm...@You.Com',
> @Subject = 'Results of Stored Procedure SPNAME'
> , @query = 'Select Information from #TTable'

Thank you
 >> Stay informed about: E-Mailing stored procedure results of job (SQL Server 2005) 

Actually, I've discovered that using 'Database Mail' would be the
recommended and preferred method to mail the procedure results in SQL
Server 2005.

Thanks
 >> Stay informed about: E-Mailing stored procedure results of job (SQL Server 2005) 

I have the same requirement. Can you please help me out? Please let me know, how you have scheduled the stored prcedure and emailed the result by using Database mail?

Thanks in advance

Rohit

> On Wednesday, August 22, 2007 11:09 AM Zamdrist wrote:

> What would be the preferred method of e-mailing the results of a
> stored procedure ran via a scheduled job? The results would be sent to
> myself, doesn't have to be fancy or anything.
>
> I have the procedure, I can create the job...anything pointers would
> be appreciated. Thank you.
>
> Steve


>> On Wednesday, August 22, 2007 11:14 AM Zamdrist wrote:

>> I should clarify...I need the result set returned by the procedure,
>> and not just success/failure of the job. Thanks.


>>> On Wednesday, August 22, 2007 11:15 AM Jef wrote:

>>> Steve,
>>>
>>> Under Sql Server Agent --> Jobs --> Right click on the job and
>>> select properties.
>>>
>>> On the notifications tab, you can elect to email the results of the
>>> job.


>>>> On Wednesday, August 22, 2007 11:18 AM Jef wrote:

>>>> On Aug 22, 11:15 am, J... DeleteThis @GoldSaucer.Com wrote:
>>>>
>>>>
>>>>
>>>> If you need to email data generated by the stored procedure, one
>>>> method is to have the Procedure create a temporary table, then use
>>>> XP_Sendmail to mail that table to yourself.
>>>>
>>>>
>>>> Exec master..XP_Sendmail @Recipients = 'YourEmail@You.Com',
>>>> @Subject = 'Results of Stored Procedure SPNAME'
>>>> , @query = 'Select Information from #TTable'


>>>>> On Wednesday, August 22, 2007 11:42 AM Zamdrist wrote:

>>>>> Thank you


>>>>>> On Wednesday, August 22, 2007 12:04 PM Zamdrist wrote:

>>>>>> Actually, I have discovered that using 'Database Mail' would be the
>>>>>> recommended and preferred method to mail the procedure results in SQL
>>>>>> Server 2005.
>>>>>>
>>>>>> Thanks


>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>>> MongoDb vs SQL Server Basic Speed Tests
>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/6f573869-c8eb-40c3-9946-2f...0163966
 >> Stay informed about: E-Mailing stored procedure results of job (SQL Server 2005)