February 2, 2009 at 8:19 am
I'm having a problem with this. I have my Database Mail setup and I can send test messages. I have made sure that SQL Agent Database Mail is enabled, I have an operator setup under SQL Server Agent called Jobs Failure and made sure it was enabled. I set up a test job that should email me on failures and successes, but I always get this message. " NOTE: Failed to notify 'Jobs Failure' via email."
I even tries restarting sql server agent after is was enable is ssa properties.
In some servers it works..but in some it doesn't
I'm at a loss.
February 2, 2009 at 9:44 am
I am assuming you have set up the Alert System within the Properties of the Agent, outside of that you do have to restart the SQL Agent after you have set these properties before it will work. Try that, and let me know if that does not get it for you.
February 2, 2009 at 9:59 am
- did you grant the operatorid usage for the mail profile ?
- if you RDC (remote desktop connection) the server, are you able to send a testmail ? (so server side)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2009 at 2:33 am
Thanks for the replies..
I restart sql server agent frm services.msc as well as sql server configuration manager.It doesn't work.
But i am able to send testmail.
February 3, 2009 at 2:40 am
Can you post the full dbmail setup ddl ?
(don't post the actual email address, but put in a dummy one)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2009 at 3:04 am
Hi
I Used Database Mail Configuration Wizard from Management Studio..
The same works in few servers..but not in others
February 3, 2009 at 3:22 am
Can you find anyting related in sqlserver errorlog or sqlagent sqlagent.out ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2009 at 4:22 am
Job History shows that "Failed to Notify Operator via mail"Error Log
Error log shows the following error message.
[264] An attempt was made to send an email when no email session has been established
February 3, 2009 at 4:41 am
santhu (2/3/2009)
Job History shows that "Failed to Notify Operator via mail"Error LogError log shows the following error message.
[264] An attempt was made to send an email when no email session has been established
I get this same msg from any SQLangent job or maintence plan (test email works fine) ... have restaretd SQL agent and still get prob. Test email shows configuration appear to be ok , any idea what i need to fix ?
February 3, 2009 at 4:43 am
Can you post the results for
select @@version
or
Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion
, Serverproperty( 'Collation' ) as Collation
, Serverproperty( 'CollationID' ) as CollationID
, Serverproperty( 'ComparisonStyle' ) as ComparisonStyle
, Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS
, Serverproperty( 'Edition' ) as Edition
, Serverproperty( 'EditionID' ) as EditionID
, Serverproperty( 'EngineEdition' ) as EngineEdition
, Serverproperty( 'InstanceName' ) as InstanceName
, Serverproperty( 'IsClustered' ) as IsClustered
, Serverproperty( 'IsFullTextInstalled' ) as IsFullTextInstalled
, Serverproperty( 'IsIntegratedSecurityOnly' ) as IsIntegratedSecurityOnly
, Serverproperty( 'IsSingleUser' ) as IsSingleUser
, Serverproperty( 'LCID' ) as LCID
, Serverproperty( 'LicenseType' ) as LicenseType
, Serverproperty( 'MachineName' ) as MachineName
, Serverproperty( 'NumLicenses' ) as NumLicenses
, Serverproperty( 'ProcessID' ) as ProcessID
, Serverproperty( 'ProductVersion' ) as ProductVersion
, Serverproperty( 'ProductLevel' ) as ProductLevel
, Serverproperty( 'ResourceLastUpdateDateTime' ) as ResourceLastUpdateDateTime
, Serverproperty( 'ResourceVersion' ) as ResourceVersion
, Serverproperty( 'ServerName' ) as ServerName
, Serverproperty( 'SqlCharSet' ) as SqlCharSet
, Serverproperty( 'SqlCharSetName' ) as SqlCharSetName
, Serverproperty( 'SqlSortOrder' ) as SqlSortOrder
, Serverproperty( 'SqlSortOrderName' ) as SqlSortOrderName
Is this 64-bit ?
http://support.microsoft.com/kb/931631
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2009 at 4:47 am
Yes it is 64 bit OS
the version is
"Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) "
February 3, 2009 at 4:50 am
Oh, you're way behind with service packs :crazy:
You are running the RTM software level.
The url I provided concerns your software level.
SP3 is current and on our servers it runs just fine.
Upgrade if you can.
[edited]
Keep in mind for e.g. SSMS menu items have been shifted/renamed for certain features. Don't panic for that.
Install "performance dashboard" ! It will help you when analysing consumers on your system (gui based) !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2009 at 5:18 am
Microsoft SQL Server 2005 - 9.00.3233.00 (X64) Mar 6 2008 21:58:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
same version for me. so deploy all updates ?
February 3, 2009 at 5:24 am
scott_lotus (2/3/2009)
Microsoft SQL Server 2005 - 9.00.3233.00 (X64) Mar 6 2008 21:58:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)same version for me. so deploy all updates ?
Are you having the same issue or are you confirming the OP should apply the sp ?
9.00.3233.00 = MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
This is pre CU7 for sp2.
SP3 = SP2 + CU9
SP3+CU1 = CP2+CU11
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2009 at 6:21 am
ALZDBA (2/3/2009)
scott_lotus (2/3/2009)
Microsoft SQL Server 2005 - 9.00.3233.00 (X64) Mar 6 2008 21:58:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)same version for me. so deploy all updates ?
Are you having the same issue or are you confirming the OP should apply the sp ?
9.00.3233.00 = MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
This is pre CU7 for sp2.
SP3 = SP2 + CU9
SP3+CU1 = CP2+CU11
sorry i should have clarified. I am saying I am having the same issue and my SQL version is almost identical. (standard / enterprise)
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply