Showing posts with label operator. Show all posts
Showing posts with label operator. Show all posts

Wednesday, March 21, 2012

Email report to Operator

While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/...ning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks

Email report to Operator

While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
Thanks
Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks

Email report to Operator

While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks

Monday, March 19, 2012

email notifications scheduled jobs

In the notifications tab of the job I have e-mail operator selected. Click on the box with the elipses to enter the email addresses. It will let me enter 2 email addresses in the e-mail name field. It looks like the field has a limited length...is there a way to manually enter several addresses?http://www.sqlmag.com/Article/ArticleID/21450/sql_server_21450.html
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=31

Email notification does not send

Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster (twice).
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, sent myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I would check 2 things:
In Surface Configuration, is Database mail enabled
When you used the wizard to setup database mail, you had to create a
profle. Is that profile set as the "default"?
tootsuite@.gmail.com wrote:
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
|||If you are installed on a 64-bit platform, you will need to continue to use
SQL Mail and Outlook Express as your SMTP client.
How to configure SQL Server Agent to send job status notifications and alert
notifications in SQL Server 2005 64-bit editions
http://support.microsoft.com/kb/908360
Anthony Thomas

<tootsuite@.gmail.com> wrote in message
news:1162832443.165881.76790@.i42g2000cwa.googlegro ups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>

Email notification does not send

Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegr oups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>

Email notification does not send

Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
ThanksI have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegroups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>

Email notification does not send

Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
ThanksI have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegroups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>

Sunday, March 11, 2012

email erroe

Hello,
I get this error message and nothing gets emailed to me. Help??
Emailing report to operator
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005
Thanks:)I get the same errror from every couple of days. Do you run GENTRAN software on the computer you are having the problem with?

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005|||Do you receive the error every time ?|||No we did not get the error every time, but almost exactly every 3 days or third time the XP_SENDMAIL function was invoked during auto-notification of backups completeing.

I found the solution earlier today the technet article is at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;320407

There is a hotfix for it to replace the Sqlmap70.dll with this version:
Version File name
----------
8.00.603 Sqlmap70.dll

I called Microsoft support and they emailed me a link to a hotfix file. I used the 1-800-936-4900 number from:
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a

This hotfix has not been fully regression tested so they are only handing it out to customers with this exact problem.

All the is needed is to stop SQL Server backup the old dll, copy the new dll to the same location, and restart SQL Server.

I will know if it is fixed if I do not have any email problems/errors this week.|||jcreed - thanks for posting the solution to your problem with xp_sendmail (which is the same problem that I had a few months ago and fixed with the same methods that you did) - however, there is an intermittent problem and a steady problem with xp_sendmail.

Anu - If your problem is every x days then I would pursue the listing by jcreed; otherwise, let me know.|||xp_sendmail: failed with mail error 0x80004005
I had the same problem a while ago after System Administartor added NT login restriction on the SQL 2000 server. This has been resolved by stop and restart the services of SQLSERVERAGENT and MSSQLSERVER. I do not know if this is the case for you but it worked with me. So try it if this happens again.

email configuration - mail profile

Hi,

I want to configure my SQL Server 2000 to send me email using operator if there is any prob in the server.

I installed office 2000 , configure microsoft outlook, I am able to send - receive emails from the account I created. my mail server is up and running fine.

How can I configure my SQL Server 2000 to send me emails.

I am not able to see any profile in support services - SQL Mail .

In control panel if I double-clicked on mail, I can only see Account - SQLMAIL which I created for my email, type (mail (default)), connection - local area network.

Appreciate your help.

Thanks.There's another recent thread with a similar (I believe) issue. You need to ensure that when you are setting up your Outlook client that you are logged in as the SQL Agent service account. So, if you SQL Agent service is set up to run under MyDomain\MySQLAgent, you need to login as MyDomain\MySQLAgent and configure Outlook. Then open EM and configure SQL Mail.

Check out SQL BOL.

Regards,

Hugh Scott

Originally posted by ramshree
Hi,

I want to configure my SQL Server 2000 to send me email using operator if there is any prob in the server.

I installed office 2000 , configure microsoft outlook, I am able to send - receive emails from the account I created. my mail server is up and running fine.

How can I configure my SQL Server 2000 to send me emails.

I am not able to see any profile in support services - SQL Mail .

In control panel if I double-clicked on mail, I can only see Account - SQLMAIL which I created for my email, type (mail (default)), connection - local area network.

Appreciate your help.

Thanks.|||I'm facing a similar problem.

How to check SQL Agent service is set up to run under wat account ?|||Right click SQL Server Agent in EM.. Click Properties ...check Service startup account.|||I Right click SQL Server Agent in EM.. Click Properties ...then can c General tab, Advanced tab and so on, i can't find ...check Service startup account.

I'm very new to SQL, i dun understand wat hmscott said "if you SQL Agent service is set up to run under MyDomain\MySQLAgent, you need to login as MyDomain\MySQLAgent and configure Outlook. "

The login is reffering to wat s/w ?|||Lets start from the beginning - Describe your problem/issues with setting up sqlmail ?