Email sent half of the time...

Hi! I have a big problem here...
I use SQL 7.0 SP4 and when the job for backup logs fails,
it send an email, as specified in the job, but only 1/2
times!!! The Net send message is sent correctly, but not
emails... Do someone know why or is experiencing this
problem?
Thanks
not sure what you mean half of the time...
first, make sure you have correctly setup email profile. Can you send a
test message via email?
"David" <david.parenteau@.compuware.com> wrote in message
news:16f1501c41819$fa018870$a301280a@.phx.gbl...
> Hi! I have a big problem here...
> I use SQL 7.0 SP4 and when the job for backup logs fails,
> it send an email, as specified in the job, but only 1/2
> times!!! The Net send message is sent correctly, but not
> emails... Do someone know why or is experiencing this
> problem?
>
> Thanks
>
|||yes, email are sent successfully when sent. By half of the
time I mean this:
I go to the Enterprise Managers, display the list of all
jobs in my SQL server. Right-click on a job and
choose "View Job History..."
The 5 most recent execution are failed. All executions has
sent NET SEND command. The first, third and fifth have
also sent an email notification. But not the second and
fourth!
Is it more clear?
Thanks

>--Original Message--
>not sure what you mean half of the time...
>first, make sure you have correctly setup email profile.
Can you send a
>test message via email?
>"David" <david.parenteau@.compuware.com> wrote in message
>news:16f1501c41819$fa018870$a301280a@.phx.gbl...
fails,
>
>.
>
|||the 5 executions are for the same job? they were executed
by the same user?

>--Original Message--
>yes, email are sent successfully when sent. By half of
the
>time I mean this:
>I go to the Enterprise Managers, display the list of all
>jobs in my SQL server. Right-click on a job and
>choose "View Job History..."
>The 5 most recent execution are failed. All executions
has
>sent NET SEND command. The first, third and fifth have
>also sent an email notification. But not the second and
>fourth!
>Is it more clear?
>Thanks
profile.
>Can you send a
>fails,
1/2
not
>.
>
|||Yes. These jobs were created by the Maintenance Plan
wizard and updated manually to set notification custom.
The first failure (and the others too) was due to a non
logged transactions (SELECT INTO). RIght now the problem
of failing is resolved, but the random problem of sending
email is not: "NOTE: Failed to notify 'teamSQLAdmin' via
email." was the reason of failed where no email was sent.
This job occurs every hours.
All emails marked as sent have been received normall in
the inbox.
David
>--Original Message--
>the 5 executions are for the same job? they were executed
>by the same user?
>the
>has
>profile.
>1/2
>not
>.
>
|||David,
Are you using MS Exchange Server? Perhaps there are exchange server outages periodically? Could you check with your exchange server admin team?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
|||Mark, yes, we use MS Exchange Server to send emails. The
mail server is dedicated on another server on the domain.
No outages are known for the mail server...
What this could involved?

>--Original Message--
>David,
>Are you using MS Exchange Server? Perhaps there are
exchange server outages periodically? Could you check with
your exchange server admin team?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>.
>

Email sent half of the time...

Hi! I have a big problem here...
I use SQL 7.0 SP4 and when the job for backup logs fails,
it send an email, as specified in the job, but only 1/2
times!!! The Net send message is sent correctly, but not
emails... Do someone know why or is experiencing this
problem?
Thanksnot sure what you mean half of the time...
first, make sure you have correctly setup email profile. Can you send a
test message via email?
"David" <david.parenteau@.compuware.com> wrote in message
news:16f1501c41819$fa018870$a301280a@.phx
.gbl...
> Hi! I have a big problem here...
> I use SQL 7.0 SP4 and when the job for backup logs fails,
> it send an email, as specified in the job, but only 1/2
> times!!! The Net send message is sent correctly, but not
> emails... Do someone know why or is experiencing this
> problem?
>
> Thanks
>|||yes, email are sent successfully when sent. By half of the
time I mean this:
I go to the Enterprise Managers, display the list of all
jobs in my SQL server. Right-click on a job and
choose "View Job History..."
The 5 most recent execution are failed. All executions has
sent NET SEND command. The first, third and fifth have
also sent an email notification. But not the second and
fourth!
Is it more clear?
Thanks

>--Original Message--
>not sure what you mean half of the time...
>first, make sure you have correctly setup email profile.
Can you send a
>test message via email?
>"David" <david.parenteau@.compuware.com> wrote in message
> news:16f1501c41819$fa018870$a301280a@.phx
.gbl...
fails,
>
>.
>|||the 5 executions are for the same job? they were executed
by the same user?

>--Original Message--
>yes, email are sent successfully when sent. By half of
the
>time I mean this:
>I go to the Enterprise Managers, display the list of all
>jobs in my SQL server. Right-click on a job and
>choose "View Job History..."
>The 5 most recent execution are failed. All executions
has
>sent NET SEND command. The first, third and fifth have
>also sent an email notification. But not the second and
>fourth!
>Is it more clear?
>Thanks
>
profile.
>Can you send a
>fails,
1/2
not
>.
>|||Yes. These jobs were created by the Maintenance Plan
wizard and updated manually to set notification custom.
The first failure (and the others too) was due to a non
logged transactions (SELECT INTO). RIght now the problem
of failing is resolved, but the random problem of sending
email is not: "NOTE: Failed to notify 'teamSQLAdmin' via
email." was the reason of failed where no email was sent.
This job occurs every hours.
All emails marked as sent have been received normall in
the inbox.
David
>--Original Message--
>the 5 executions are for the same job? they were executed
>by the same user?
>
>the
>has
>profile.
>1/2
>not
>.
>|||David,
Are you using MS Exchange Server? Perhaps there are exchange server outages
periodically? Could you check with your exchange server admin team?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Mark, yes, we use MS Exchange Server to send emails. The
mail server is dedicated on another server on the domain.
No outages are known for the mail server...
What this could involved?

>--Original Message--
>David,
>Are you using MS Exchange Server? Perhaps there are
exchange server outages periodically? Could you check with
your exchange server admin team?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>.
>

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?
Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/de...us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

EM does not install

I have a strange SQL Standart installation on Win2k
server, sp4: I selected the server components, but the EM
is not available in the program menu. I have already
installed the same SQL on the previous machine and the
installation was OK. What I'm missing? Do I need to
reinstall SQl server? Can I do this without uninstall the
existing instance?
ThanksTry reinstalling "client tools only"
--
-Vishal
MJ <mschwenger@.cca-lv.com> wrote in message
news:2f6b01c379df$9b8b6e60$a601280a@.phx.gbl...
> I have a strange SQL Standart installation on Win2k
> server, sp4: I selected the server components, but the EM
> is not available in the program menu. I have already
> installed the same SQL on the previous machine and the
> installation was OK. What I'm missing? Do I need to
> reinstall SQl server? Can I do this without uninstall the
> existing instance?
> Thanks