--=_NextPart_000_002A_01C89897.E2CD2D00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have two jobs configured to e-mail myself on completion, but I am not = currently receiving these notifications.
The SQL Agent is configured to use database mail, with a specific = private profile. Of note is that the button to "Test" the mail profile = is grayed out on the Alert System tab. When I execute sp_send_dbmail = using the e-mail address from the operator and use the profile name = defined in the SQL Agent properties, I receive an e-mail. However the = jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of the profile in the = sysmail_profile table. The e-mail does not appear in sysmail_mailitems = and sysmail_send_retries is empty. So the job notification is not = getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_002A_01C89897.E2CD2D00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have two jobs configured to e-mail = myself on completion, but I am not currently receiving these notifications.
The SQL Agent is configured to use = database mail, with a specific private profile. Of note is that the button to = "Test" the mail profile is grayed out on the Alert System tab. When I execute = sp_send_dbmail using the e-mail address from the operator and use the = profile name defined in the SQL Agent properties, I receive an e-mail. = However the jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of = the profile in the sysmail_profile table. The e-mail does not appear in sysmail_mailitems and sysmail_send_retries is empty. So the job notification is not getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_002A_01C89897.E2CD2D00--This is a multi-part message in MIME format.
--=_NextPart_000_0065_01C898E3.854A0D00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
What account is SQL Agent running under?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23Tec6mLmIHA.3780@.TK2MSFTNGP06.phx.gbl...
I have two jobs configured to e-mail myself on completion, but I am =not currently receiving these notifications.
The SQL Agent is configured to use database mail, with a specific =private profile. Of note is that the button to "Test" the mail profile =is grayed out on the Alert System tab. When I execute sp_send_dbmail =using the e-mail address from the operator and use the profile name =defined in the SQL Agent properties, I receive an e-mail. However the =jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of the profile in the =sysmail_profile table. The e-mail does not appear in sysmail_mailitems =and sysmail_send_retries is empty. So the job notification is not =getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0065_01C898E3.854A0D00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi
What account is SQL Agent running under?
John
"Rubens"
I have two jobs configured to e-mail =myself on completion, but I am not currently receiving these notifications.
The SQL Agent is configured to use =database mail, with a specific private profile. Of note is that the button to ="Test" the mail profile is grayed out on the Alert System tab. When I =execute sp_send_dbmail using the e-mail address from the operator and use the =profile name defined in the SQL Agent properties, I receive an e-mail. =However the jobs themselves are not sending me any e-mail.
I've also confirmed the correct name =of the profile in the sysmail_profile table. The e-mail does not appear =in sysmail_mailitems and sysmail_send_retries is empty. So the job notification is not getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0065_01C898E3.854A0D00--|||This is a multi-part message in MIME format.
--=_NextPart_000_0067_01C898BF.22C59A10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It is running under a domain account that is an administrator on the =server, which is the same account the SQL Server service is running =under (I haven't split them up and restricted it as is recommended).
Thank-you,
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:O6%231lsNmIHA.1208@.TK2MSFTNGP05.phx.gbl...
Hi
What account is SQL Agent running under?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23Tec6mLmIHA.3780@.TK2MSFTNGP06.phx.gbl...
I have two jobs configured to e-mail myself on completion, but I am =not currently receiving these notifications.
The SQL Agent is configured to use database mail, with a specific =private profile. Of note is that the button to "Test" the mail profile =is grayed out on the Alert System tab. When I execute sp_send_dbmail =using the e-mail address from the operator and use the profile name =defined in the SQL Agent properties, I receive an e-mail. However the =jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of the profile in the =sysmail_profile table. The e-mail does not appear in sysmail_mailitems =and sysmail_send_retries is empty. So the job notification is not =getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0067_01C898BF.22C59A10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
It is running under a domain account =that is an administrator on the server, which is the same account the SQL Server =service is running under (I haven't split them up and restricted it as is recommended).
Thank-you,
Rubens
"John Bell"
Hi
What account is SQL Agent running under?
John
"Rubens"
I have two jobs configured to =e-mail myself on completion, but I am not currently receiving these notifications.
The SQL Agent is configured to use =database mail, with a specific private profile. Of note is that the =button to "Test" the mail profile is grayed out on the Alert System tab. =When I execute sp_send_dbmail using the e-mail address from the operator =and use the profile name defined in the SQL Agent properties, I receive an e-mail. However the jobs themselves are not sending me any e-mail.
I've also confirmed the correct =name of the profile in the sysmail_profile table. The e-mail does not =appear in sysmail_mailitems and sysmail_send_retries is empty. So the =job notification is not getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0067_01C898BF.22C59A10--|||This is a multi-part message in MIME format.
--=_NextPart_000_0084_01C898EA.086587E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
And were you logged in as this account when you tested sp_send_dbmail?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23A5C6DOmIHA.5084@.TK2MSFTNGP04.phx.gbl...
It is running under a domain account that is an administrator on the =server, which is the same account the SQL Server service is running =under (I haven't split them up and restricted it as is recommended).
Thank-you,
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:O6%231lsNmIHA.1208@.TK2MSFTNGP05.phx.gbl...
Hi
What account is SQL Agent running under?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23Tec6mLmIHA.3780@.TK2MSFTNGP06.phx.gbl...
I have two jobs configured to e-mail myself on completion, but I =am not currently receiving these notifications.
The SQL Agent is configured to use database mail, with a specific =private profile. Of note is that the button to "Test" the mail profile =is grayed out on the Alert System tab. When I execute sp_send_dbmail =using the e-mail address from the operator and use the profile name =defined in the SQL Agent properties, I receive an e-mail. However the =jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of the profile in the =sysmail_profile table. The e-mail does not appear in sysmail_mailitems =and sysmail_send_retries is empty. So the job notification is not =getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0084_01C898EA.086587E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi
And were you logged in as this account =when you tested sp_send_dbmail?
John
"Rubens"
It is running under a domain account =that is an administrator on the server, which is the same account the SQL Server =service is running under (I haven't split them up and restricted it as is recommended).
Thank-you,
Rubens
"John Bell"
Hi
What account is SQL Agent running under?
John
"Rubens"
I have two jobs configured to =e-mail myself on completion, but I am not currently receiving these notifications.
The SQL Agent is configured to =use database mail, with a specific private profile. Of note is that the =button to "Test" the mail profile is grayed out on the Alert System =tab. When I execute sp_send_dbmail using the e-mail address from the =operator and use the profile name defined in the SQL Agent properties, I =receive an e-mail. However the jobs themselves are not sending me any e-mail.
I've also confirmed the correct =name of the profile in the sysmail_profile table. The e-mail does not =appear in sysmail_mailitems and sysmail_send_retries is empty. So the =job notification is not getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0084_01C898EA.086587E0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0012_01C898D9.9D37BCA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hmmm, come to think of it, no I wasn't. I will have to test that when =back in the office tomorrow. I will let you know.
Thanks John.
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:erH9oGOmIHA.1184@.TK2MSFTNGP04.phx.gbl...
Hi
And were you logged in as this account when you tested sp_send_dbmail?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23A5C6DOmIHA.5084@.TK2MSFTNGP04.phx.gbl...
It is running under a domain account that is an administrator on the =server, which is the same account the SQL Server service is running =under (I haven't split them up and restricted it as is recommended).
Thank-you,
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:O6%231lsNmIHA.1208@.TK2MSFTNGP05.phx.gbl...
Hi
What account is SQL Agent running under?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23Tec6mLmIHA.3780@.TK2MSFTNGP06.phx.gbl...
I have two jobs configured to e-mail myself on completion, but I =am not currently receiving these notifications.
The SQL Agent is configured to use database mail, with a =specific private profile. Of note is that the button to "Test" the mail =profile is grayed out on the Alert System tab. When I execute =sp_send_dbmail using the e-mail address from the operator and use the =profile name defined in the SQL Agent properties, I receive an e-mail. =However the jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of the profile in the =sysmail_profile table. The e-mail does not appear in sysmail_mailitems =and sysmail_send_retries is empty. So the job notification is not =getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0012_01C898D9.9D37BCA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hmmm, come to think of it, no I =wasn't. I will have to test that when back in the office tomorrow. I will =let you know.
Thanks John.
Rubens
"John Bell"
Hi
And were you logged in as this =account when you tested sp_send_dbmail?
John
"Rubens"
It is running under a domain =account that is an administrator on the server, which is the same account the SQL =Server service is running under (I haven't split them up and restricted it =as is recommended).
Thank-you,
Rubens
"John Bell"
Hi
What account is SQL Agent running = under?
John
"Rubens"
I have two jobs configured to =e-mail myself on completion, but I am not currently receiving these notifications.
The SQL Agent is configured to =use database mail, with a specific private profile. Of note is that the =button to "Test" the mail profile is grayed out on the Alert System =tab. When I execute sp_send_dbmail using the e-mail address from the =operator and use the profile name defined in the SQL Agent properties, I =receive an e-mail. However the jobs themselves are not sending me =any e-mail.
I've also confirmed the correct =name of the profile in the sysmail_profile table. The e-mail does not =appear in sysmail_mailitems and sysmail_send_retries is empty. So =the job notification is not getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0012_01C898D9.9D37BCA0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000E_01C89951.401BBEE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Yes, I was able to send an e-mail using T-SQL when logged in with the =account the SQL Server service / agent was using. I was able to fix the =problem, although I am not sure if it's a permanent solution.
The job operator e-mail address was a distribution list on Exchange. I =changed the e-mail address to include my own, ran the job, and one alert =came through fine. Then I sent it only to my account, again, worked =fine. I then retyped the operator e-mail address back in of the =distribution list and it succeeded. The one thing I am positive of is =that the e-mail address was correct right from the start because I use =the same e-mail address in the Pagers section. This was and is =identical to what was in the E-mail name of the operator.
Does this sound like a bug? I guess it's a little concerning =considering one of the benefits of database mail is it being SMTP based =and supposed to be a lot more reliable.
Thanks,
Rubens
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:e1A60tPmIHA.2268@.TK2MSFTNGP02.phx.gbl...
Hmmm, come to think of it, no I wasn't. I will have to test that when =back in the office tomorrow. I will let you know.
Thanks John.
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:erH9oGOmIHA.1184@.TK2MSFTNGP04.phx.gbl...
Hi
And were you logged in as this account when you tested =sp_send_dbmail?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23A5C6DOmIHA.5084@.TK2MSFTNGP04.phx.gbl...
It is running under a domain account that is an administrator on =the server, which is the same account the SQL Server service is running =under (I haven't split them up and restricted it as is recommended).
Thank-you,
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:O6%231lsNmIHA.1208@.TK2MSFTNGP05.phx.gbl...
Hi
What account is SQL Agent running under?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23Tec6mLmIHA.3780@.TK2MSFTNGP06.phx.gbl...
I have two jobs configured to e-mail myself on completion, but =I am not currently receiving these notifications.
The SQL Agent is configured to use database mail, with a =specific private profile. Of note is that the button to "Test" the mail =profile is grayed out on the Alert System tab. When I execute =sp_send_dbmail using the e-mail address from the operator and use the =profile name defined in the SQL Agent properties, I receive an e-mail. =However the jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of the profile in the =sysmail_profile table. The e-mail does not appear in sysmail_mailitems =and sysmail_send_retries is empty. So the job notification is not =getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_000E_01C89951.401BBEE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Yes, I was able to send an e-mail using =T-SQL when logged in with the account the SQL Server service / agent was =using. I was able to fix the problem, although I am not sure if it=92s a permanent solution.
The job operator e-mail address was a =distribution list on Exchange. I changed the e-mail address to include my =own, ran the job, and one alert came through fine. Then I sent it only to =my account, again, worked fine. I then retyped the operator e-mail =address back in of the distribution list and it succeeded. The one thing I =am positive of is that the e-mail address was correct right from the start =because I use the same e-mail address in the Pagers section. This was and =is identical to what was in the E-mail name of the operator.
Does this sound like a bug? I =guess it=92s a little concerning considering one of the benefits of database mail is it =being SMTP based and supposed to be a lot more reliable.
Thanks,
Rubens
"Rubens"
Hmmm, come to think of it, no I =wasn't. I will have to test that when back in the office tomorrow. I will =let you know.
Thanks John.
Rubens
"John Bell"
Hi
And were you logged in as this =account when you tested sp_send_dbmail?
John
"Rubens"
It is running under a domain =account that is an administrator on the server, which is the same account the SQL =Server service is running under (I haven't split them up and restricted =it as is recommended).
Thank-you,
Rubens
"John Bell"
Hi
What account is SQL Agent =running under?
John
"Rubens"
I have two jobs configured to =e-mail myself on completion, but I am not currently receiving =these notifications.
The SQL Agent is configured =to use database mail, with a specific private profile. Of note =is that the button to "Test" the mail profile is grayed out on the =Alert System tab. When I execute sp_send_dbmail using the =e-mail address from the operator and use the profile name defined in =the SQL Agent properties, I receive an e-mail. However the jobs themselves are not sending me any e-mail.
I've also confirmed the =correct name of the profile in the sysmail_profile table. The e-mail =does not appear in sysmail_mailitems and sysmail_send_retries is =empty. So the job notification is not getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_000E_01C89951.401BBEE0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0019_01C89953.299E61C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I've just noticed another issue. I've created all my maintenance plans =using the wizard. When I go into the "Reporting and Logging" section =for the maintenance plan, I've selected the "Send report to an email =recipient" check box, the recipient being the same one that the job =alert sends to. However, I am not receiving the e-mail report. =Instead, I am only getting an e-mail from the job saying it has =completed. I don't get a report from the maintenance plan. I have also =confirmed that the logging file is created in a folder on the server.
Any idea why I am not getting this report in an e-mail?
Thank-you,
Rubens
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:eC7QYMXmIHA.5684@.TK2MSFTNGP03.phx.gbl...
Yes, I was able to send an e-mail using T-SQL when logged in with the =account the SQL Server service / agent was using. I was able to fix the =problem, although I am not sure if it's a permanent solution.
The job operator e-mail address was a distribution list on Exchange. =I changed the e-mail address to include my own, ran the job, and one =alert came through fine. Then I sent it only to my account, again, =worked fine. I then retyped the operator e-mail address back in of the =distribution list and it succeeded. The one thing I am positive of is =that the e-mail address was correct right from the start because I use =the same e-mail address in the Pagers section. This was and is =identical to what was in the E-mail name of the operator.
Does this sound like a bug? I guess it's a little concerning =considering one of the benefits of database mail is it being SMTP based =and supposed to be a lot more reliable.
Thanks,
Rubens
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:e1A60tPmIHA.2268@.TK2MSFTNGP02.phx.gbl...
Hmmm, come to think of it, no I wasn't. I will have to test that =when back in the office tomorrow. I will let you know.
Thanks John.
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:erH9oGOmIHA.1184@.TK2MSFTNGP04.phx.gbl...
Hi
And were you logged in as this account when you tested =sp_send_dbmail?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23A5C6DOmIHA.5084@.TK2MSFTNGP04.phx.gbl...
It is running under a domain account that is an administrator on =the server, which is the same account the SQL Server service is running =under (I haven't split them up and restricted it as is recommended).
Thank-you,
Rubens
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:O6%231lsNmIHA.1208@.TK2MSFTNGP05.phx.gbl...
Hi
What account is SQL Agent running under?
John
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:%23Tec6mLmIHA.3780@.TK2MSFTNGP06.phx.gbl...
I have two jobs configured to e-mail myself on completion, =but I am not currently receiving these notifications.
The SQL Agent is configured to use database mail, with a =specific private profile. Of note is that the button to "Test" the mail =profile is grayed out on the Alert System tab. When I execute =sp_send_dbmail using the e-mail address from the operator and use the =profile name defined in the SQL Agent properties, I receive an e-mail. =However the jobs themselves are not sending me any e-mail.
I've also confirmed the correct name of the profile in the =sysmail_profile table. The e-mail does not appear in sysmail_mailitems =and sysmail_send_retries is empty. So the job notification is not =getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0019_01C89953.299E61C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I've just noticed another issue. =I've created all my maintenance plans using the wizard. When I go into the ="Reporting and Logging" section for the maintenance plan, I've selected the "Send =report to an email recipient" check box, the recipient being the same one that the =job alert sends to. However, I am not receiving the e-mail =report. Instead, I am only getting an e-mail from the job saying it has =completed. I don't get a report from the maintenance plan. I have also =confirmed that the logging file is created in a folder on the server.
Any idea why I am not getting this =report in an e-mail?
Thank-you,
Rubens
"Rubens"
Yes, I was able to send an e-mail =using T-SQL when logged in with the account the SQL Server service / agent was using. I was able to fix the problem, although I am not sure if =it=92s a permanent solution.
The job operator e-mail address was a = distribution list on Exchange. I changed the e-mail address to include my own, ran the job, and one alert came through =fine. Then I sent it only to my account, again, worked fine. I then retyped =the operator e-mail address back in of the distribution list and it succeeded. The one thing I am positive of is that the e-mail =address was correct right from the start because I use the same e-mail address in =the Pagers section. This was and is identical to what was in the =E-mail name of the operator.
Does this sound like a bug? I =guess it=92s a little concerning considering one of the benefits of database mail is =it being SMTP based and supposed to be a lot more reliable.
Thanks,
Rubens
"Rubens"
Hmmm, come to think of it, no I =wasn't. I will have to test that when back in the office tomorrow. I =will let you know.
Thanks John.
Rubens
"John Bell"
Hi
And were you logged in as this =account when you tested sp_send_dbmail?
John
"Rubens"
It is running under a domain =account that is an administrator on the server, which is the same account the =SQL Server service is running under (I haven't split them up and =restricted it as is recommended).
Thank-you,
Rubens
"John Bell"
Hi
What account is SQL Agent =running under?
John
"Rubens"
I have two jobs configured =to e-mail myself on completion, but I am not currently receiving =these notifications.
The SQL Agent is configured =to use database mail, with a specific private profile. Of =note is that the button to "Test" the mail profile is grayed out on =the Alert System tab. When I execute sp_send_dbmail using =the e-mail address from the operator and use the profile name =defined in the SQL Agent properties, I receive an e-mail. However =the jobs themselves are not sending me any e-mail.
I've also confirmed the =correct name of the profile in the sysmail_profile table. The e-mail =does not appear in sysmail_mailitems and sysmail_send_retries is =empty. So the job notification is not getting queued.
Any ideas?
Thank-you,
Rubens
--=_NextPart_000_0019_01C89953.299E61C0--
No comments:
Post a Comment