|
Home > Archive > MS SQL Server > June 2005 > Receiving email from job output when not indicated...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Receiving email from job output when not indicated...
|
|
| Jeffrey Sheldon via SQLMonster.com 2005-06-29, 9:23 am |
| Ok this is anal but bothering me. I have various jobs setup in Enterprise
manager (backup, t-log backup, optimization, etc.)
On the Job event I have indicated to email our Help Desk ONLY when the job
fails.
However regardless of the job outcome we receive an email everytime it runs.
Anyone else experience this?
Jeff
--
Message posted via http://www.webservertalk.com
| |
| Tibor Karaszi 2005-06-29, 9:23 am |
| I haven't seen that. One possible reason is that you have defined a pager notification and it is
out-of hours of the operator is disabled, and the one receiving the email is a fail-safe operator.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Jeffrey Sheldon via webservertalk.com" <forum@webservertalk.com> wrote in message
news:5092DC40D4F30@w
ebservertalk.com...
> Ok this is anal but bothering me. I have various jobs setup in Enterprise
> manager (backup, t-log backup, optimization, etc.)
>
> On the Job event I have indicated to email our Help Desk ONLY when the job
> fails.
>
> However regardless of the job outcome we receive an email everytime it runs.
>
> Anyone else experience this?
>
> Jeff
>
> --
> Message posted via http://www.webservertalk.com
| |
| Jeffrey Sheldon via SQLMonster.com 2005-06-29, 11:23 am |
| Tibor,
I have nothing in pager information in SQL Server Agent properities but I do
have Email Help Desk as the Fail-safe.
Are you saying if I have an entry in this preference that it will disregard
my job preference notifications?
--
Message posted via http://www.webservertalk.com
| |
| Tibor Karaszi 2005-06-29, 1:23 pm |
| > Are you saying if I have an entry in this preference that it will disregard
> my job preference notifications?
No, but if someone is to be notified by pager (say for a job completion) and that someone isn't
available, then the fail safe operator is notified. If you don't have any pager notification for the
job completion, then the fail safe shouldn't kick in. But perhaps there's a bug in the fail safe
handling? Try removing this as a test (if possible).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Jeffrey Sheldon via webservertalk.com" <forum@webservertalk.com> wrote in message
news:5093F0C4AC8A0@w
ebservertalk.com...
> Tibor,
>
> I have nothing in pager information in SQL Server Agent properities but I do
> have Email Help Desk as the Fail-safe.
>
> Are you saying if I have an entry in this preference that it will disregard
> my job preference notifications?
>
> --
> Message posted via http://www.webservertalk.com
| |
| Jeffrey Sheldon via SQLMonster.com 2005-06-30, 9:23 am |
| Tibor,
I found it....I guess if you check Email Operator on the Datbase Maintenance
Plan on Enterprise Manager, this supercedes any option on the SQL Server
Agent.
Once I unchecked on the maintenance plan, email to..., I do not receive
emails for successful operations and do receive email for failed operations.
Jeff
--
Message posted via http://www.webservertalk.com
| |
| Tibor Karaszi 2005-06-30, 9:23 am |
| Ahh, so the mail was went by the maint plan (sqlmaint.exe), where the jobs by themselves doesn't
send email. Yes, these are two different and independent configurations.
Good catch!
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Jeffrey Sheldon via webservertalk.com" <forum@webservertalk.com> wrote in message
news:509F7BD6A7E00@w
ebservertalk.com...
> Tibor,
>
> I found it....I guess if you check Email Operator on the Datbase Maintenance
> Plan on Enterprise Manager, this supercedes any option on the SQL Server
> Agent.
>
> Once I unchecked on the maintenance plan, email to..., I do not receive
> emails for successful operations and do receive email for failed operations.
>
> Jeff
>
> --
> Message posted via http://www.webservertalk.com
|
|
|
|
|