Sql Jobs Error Emails...

[ghazni]

Package lo send mail task leka potey how does the job send mails to the team...

[9Pardhu]

In SSMS Go to Management and Database mail in it and configure that.

[9Pardhu]

if it doesnot work write the code and add as an step in the job.

[Bairagi From Bapatla]

Job schedule chesinappudu oka option untadi... package fail ayithe fail ayyindani particular mem ki mail, msg pampachu ani andhulo nee details isthe fail ayithe pampidi...

[ghazni]

[quote name='pardhu9' timestamp='1378478588' post='1304212464']
In SSMS Go to Management and Database mail in it and configure that.
[/quote]
good already unavi ela vastunayo ela kanukovadam.....

[ghazni]

[quote name='Bairagi From Bapatla' timestamp='1378478680' post='1304212473']
Job schedule chesinappudu oka option untadi... package fail ayithe fail ayyindani particular mem ki mail, msg pampachu ani andhulo nee details isthe fail ayithe pampidi...
[/quote]
[quote name='pardhu9' timestamp='1378478634' post='1304212466']
if it doesnot work write the code and add as an step in the job.
[/quote]

error emails vastunayi naku kani asalu aa job fail ayindo particular ga teliyatledu.... sql agent loki vali chustey aa time ki a job fail ayindo chusi dani follow avtuna...

[loveindia]

[quote name='ghazni' timestamp='1378478839' post='1304212488']
error emails vastunayi naku kani asalu aa job fail ayindo particular ga teliyatledu.... sql agent loki vali chustey aa time ki a job fail ayindo chusi dani follow avtuna...
[/quote]

It will allow you to choose what to send in the email.. you may have to print the error number etc so that u can understand..

your starting point would be

http://www.sqldbadiaries.com/2010/07/27/an-attempt-was-made-to-send-an-email-when-no-email-session-has-been-established-sql-server-2005/

in that link you will know where to find if the email connection is established or not.. Good luck.

[ghazni]

[quote name='loveindia' timestamp='1378479146' post='1304212515']

It will allow you to choose what to send in the email.. you may have to print the error number etc so that u can understand..

your starting point would be

[url="http://www.sqldbadiaries.com/2010/07/27/an-attempt-was-made-to-send-an-email-when-no-email-session-has-been-established-sql-server-2005/"]http://www.sqldbadia...ql-server-2005/[/url]

in that link you will know where to find if the email connection is established or not.. Good luck.
[/quote]
Thank you mama... ma dantlo okadu unadu vadiki full experience aina in security feeling edi chepadu.... nadi aina ssrs but urike undadam enduku ani analyze chestuna....

[SwamyRaRa]

GP