[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Job and mail notification

Kalyan

4/1/2007 3:50:00 PM

I am using SQL Server 2005, created a operator (say JobStatus). I scheduled
a job to run. On Notification property of job, i enabled e-mail in action to
perform when job completes, I selected operator Jobstatus and when the job
succeeds. I ran the job it ran successfully but i never recived email
notification. Is there any other setting i need todo?


thanks
kk
2 Answers

Tibor Karaszi

4/1/2007 5:05:00 PM

0

That should be it. Does the mail config work? Are you using SQL Mail of Database Mail? Did you try
sending email using xp_sendmail or sp_send_dbmail? Anything in the Agent log?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/d...
http://sqlblog.com/blogs/tib...


"Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
news:94BBD1CB-F9D2-4E8C-83C0-964B5754170E@microsoft.com...
>I am using SQL Server 2005, created a operator (say JobStatus). I scheduled
> a job to run. On Notification property of job, i enabled e-mail in action to
> perform when job completes, I selected operator Jobstatus and when the job
> succeeds. I ran the job it ran successfully but i never recived email
> notification. Is there any other setting i need todo?
>
>
> thanks
> kk
>

TheSQLGuru

4/1/2007 6:06:00 PM

0

Re-verify your Database Mail setup. There are quite a number of steps to
getting it fully functional. The one that seems to trip up most users is
that the service account used by the sql agent service has to be a member of
the DatabaseMailUserRole in the MSDB database.

--
TheSQLGuru
President
Indicium Resources, Inc.

"Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
news:94BBD1CB-F9D2-4E8C-83C0-964B5754170E@microsoft.com...
>I am using SQL Server 2005, created a operator (say JobStatus). I
>scheduled
> a job to run. On Notification property of job, i enabled e-mail in action
> to
> perform when job completes, I selected operator Jobstatus and when the
> job
> succeeds. I ran the job it ran successfully but i never recived email
> notification. Is there any other setting i need todo?
>
>
> thanks
> kk
>