Mailsend program

Hi All,

I have installed SQL Server 2005 and created a job. I made the job failed to test the mailsend program. The notification step that uses the mailsend succeeded but I did not get an email. I am using mailsend program on SQL Server 2000 and it works fine. I am really stomped and don't know what to do to fix it?

Thanks.what are you using to send mail? xp_sendmail? xp_smtpmail? CDOSYS? CDONTS?

I feel stomped everyday.|||I am using xp_sendmail.|||have you...

installed outlook on your DB server?

is the agent using a network account mapped to an exhange mail profile?

have you tested sending mail directly from the mail client?

have you started a sql mail client session with xp_startmail?|||Yes, Outlook Express

How can I check it? Our network guys set up the server

Yes and it was successfull

I have read in BOL that this feature will be removed in a future version of Microsoft SQL Server.|||Have you opened the "Surface Area Configuration" tool and looked under feature configuration to enable SQL Mail?

BTW ... Database Mail is the preferred method with 2005.|||I'll try Database Mail option|||Database Mail is MUCH better. It takes a bit of configuration, but it's really nice.

hmscott|||On SQL Server 2005 use sp_senddbmail. It sends mail using SMTP and uses service broker for queuing mails to be sent. No need for Outlook on the server anymore, and the mail sending process is 100% asyncronous.

Mail notification to admin for conflicts

Dear Friends
Can it be possible that i get email for the conflict as
and when they appear.
Your guiaence will be helpful to solve my problem.
Best regards
Sharad
with windows synchronization manager if you select interactive resolver you
will get a dialog that pops up on the client notifiying them of a resolution
and they can solve it there.
Other than that you will have to code something yourself.
You might also want to look at the Microsoft SQL Conflict Resolver library.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Sharad" <niitmalad@.yahoo.co.in> wrote in message
news:0b7301c4ec1e$8b4c3d60$a301280a@.phx.gbl...
> Dear Friends
> Can it be possible that i get email for the conflict as
> and when they appear.
> Your guiaence will be helpful to solve my problem.
> Best regards
> Sharad

mail notification of SQL shutdown

Hi,
Is it possible to config SQL mail send out a message when machine reboot or
SQL server shutdown?
Thanks,
Jack
Hi
You can't do it during the shutdown process as you may not be notified, if
it is a quick one, there is an OS shut down or crash.
For Startup, create a Stored Procedure. Then with sp_procoption, mark it for
startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds before
you send the mail. This gives the various MAPI components time to be loaded
by SQL Agent before you start to throw work their way.
If the SQL Server is really critical, it is best to get an external
monitoring tool to monitor the OS and SQL Server. Self monitoring on
software has its problems...It can't report on itself very well as it may
not be in a state to monitor itself.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jack" <chongh.hc@.gmail.com> wrote in message
news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is it possible to config SQL mail send out a message when machine reboot
> or SQL server shutdown?
> Thanks,
> Jack
>
|||Hi, Mike,
Thanks for your reply, I'll try your suggestion.
To help me better understand this question, I have to know "how SQL react if
OS send shutdown command to it?", if I can know any trigger force SQL
server/agent shutdown, can we apply a SP run first before SQL server/agent
proceed shutdown command that OS send to it.
Hope you can understand me , my English is not good.
Regards,
Chong
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi
> You can't do it during the shutdown process as you may not be notified, if
> it is a quick one, there is an OS shut down or crash.
> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
> before you send the mail. This gives the various MAPI components time to
> be loaded by SQL Agent before you start to throw work their way.
> If the SQL Server is really critical, it is best to get an external
> monitoring tool to monitor the OS and SQL Server. Self monitoring on
> software has its problems...It can't report on itself very well as it may
> not be in a state to monitor itself.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jack" <chongh.hc@.gmail.com> wrote in message
> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>
|||AFAIK, SQL behaves as any other service which is sent the STOP command - it
shuts down immediately. You would probably need to code your own WMI
application to trap service events, or use some 3rd-party monitoring
software.
One thing you might want to try is setting up a T-SQL job on another SQL
Server to try and connect (using osql.exe for example) and notify you if it
fails.
Adrian
"Jack" <chongh.hc@.gmail.com> wrote in message
news:%23biEK%23cPFHA.3336@.TK2MSFTNGP09.phx.gbl...
> Hi, Mike,
> Thanks for your reply, I'll try your suggestion.
> To help me better understand this question, I have to know "how SQL react
> if OS send shutdown command to it?", if I can know any trigger force SQL
> server/agent shutdown, can we apply a SP run first before SQL server/agent
> proceed shutdown command that OS send to it.
> Hope you can understand me , my English is not good.
> Regards,
> Chong
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
>

mail notification of SQL shutdown

Hi,
Is it possible to config SQL mail send out a message when machine reboot or
SQL server shutdown?
Thanks,
JackHi
You can't do it during the shutdown process as you may not be notified, if
it is a quick one, there is an OS shut down or crash.
For Startup, create a Stored Procedure. Then with sp_procoption, mark it for
startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds before
you send the mail. This gives the various MAPI components time to be loaded
by SQL Agent before you start to throw work their way.
If the SQL Server is really critical, it is best to get an external
monitoring tool to monitor the OS and SQL Server. Self monitoring on
software has its problems...It can't report on itself very well as it may
not be in a state to monitor itself.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jack" <chongh.hc@.gmail.com> wrote in message
news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is it possible to config SQL mail send out a message when machine reboot
> or SQL server shutdown?
> Thanks,
> Jack
>|||Hi, Mike,
Thanks for your reply, I'll try your suggestion.
To help me better understand this question, I have to know "how SQL react if
OS send shutdown command to it?", if I can know any trigger force SQL
server/agent shutdown, can we apply a SP run first before SQL server/agent
proceed shutdown command that OS send to it.
Hope you can understand me , my English is not good.
Regards,
Chong
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi
> You can't do it during the shutdown process as you may not be notified, if
> it is a quick one, there is an OS shut down or crash.
> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
> before you send the mail. This gives the various MAPI components time to
> be loaded by SQL Agent before you start to throw work their way.
> If the SQL Server is really critical, it is best to get an external
> monitoring tool to monitor the OS and SQL Server. Self monitoring on
> software has its problems...It can't report on itself very well as it may
> not be in a state to monitor itself.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jack" <chongh.hc@.gmail.com> wrote in message
> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>|||AFAIK, SQL behaves as any other service which is sent the STOP command - it
shuts down immediately. You would probably need to code your own WMI
application to trap service events, or use some 3rd-party monitoring
software.
One thing you might want to try is setting up a T-SQL job on another SQL
Server to try and connect (using osql.exe for example) and notify you if it
fails.
Adrian
"Jack" <chongh.hc@.gmail.com> wrote in message
news:%23biEK%23cPFHA.3336@.TK2MSFTNGP09.phx.gbl...
> Hi, Mike,
> Thanks for your reply, I'll try your suggestion.
> To help me better understand this question, I have to know "how SQL react
> if OS send shutdown command to it?", if I can know any trigger force SQL
> server/agent shutdown, can we apply a SP run first before SQL server/agent
> proceed shutdown command that OS send to it.
> Hope you can understand me , my English is not good.
> Regards,
> Chong
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
>

mail notification of SQL shutdown

Hi,
Is it possible to config SQL mail send out a message when machine reboot or
SQL server shutdown?
Thanks,
JackHi
You can't do it during the shutdown process as you may not be notified, if
it is a quick one, there is an OS shut down or crash.
For Startup, create a Stored Procedure. Then with sp_procoption, mark it for
startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds before
you send the mail. This gives the various MAPI components time to be loaded
by SQL Agent before you start to throw work their way.
If the SQL Server is really critical, it is best to get an external
monitoring tool to monitor the OS and SQL Server. Self monitoring on
software has its problems...It can't report on itself very well as it may
not be in a state to monitor itself.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jack" <chongh.hc@.gmail.com> wrote in message
news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is it possible to config SQL mail send out a message when machine reboot
> or SQL server shutdown?
> Thanks,
> Jack
>|||Hi, Mike,
Thanks for your reply, I'll try your suggestion.
To help me better understand this question, I have to know "how SQL react if
OS send shutdown command to it?", if I can know any trigger force SQL
server/agent shutdown, can we apply a SP run first before SQL server/agent
proceed shutdown command that OS send to it.
Hope you can understand me , my English is not good.
Regards,
Chong
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi
> You can't do it during the shutdown process as you may not be notified, if
> it is a quick one, there is an OS shut down or crash.
> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
> before you send the mail. This gives the various MAPI components time to
> be loaded by SQL Agent before you start to throw work their way.
> If the SQL Server is really critical, it is best to get an external
> monitoring tool to monitor the OS and SQL Server. Self monitoring on
> software has its problems...It can't report on itself very well as it may
> not be in a state to monitor itself.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jack" <chongh.hc@.gmail.com> wrote in message
> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> Is it possible to config SQL mail send out a message when machine reboot
>> or SQL server shutdown?
>> Thanks,
>> Jack
>|||AFAIK, SQL behaves as any other service which is sent the STOP command - it
shuts down immediately. You would probably need to code your own WMI
application to trap service events, or use some 3rd-party monitoring
software.
One thing you might want to try is setting up a T-SQL job on another SQL
Server to try and connect (using osql.exe for example) and notify you if it
fails.
Adrian
"Jack" <chongh.hc@.gmail.com> wrote in message
news:%23biEK%23cPFHA.3336@.TK2MSFTNGP09.phx.gbl...
> Hi, Mike,
> Thanks for your reply, I'll try your suggestion.
> To help me better understand this question, I have to know "how SQL react
> if OS send shutdown command to it?", if I can know any trigger force SQL
> server/agent shutdown, can we apply a SP run first before SQL server/agent
> proceed shutdown command that OS send to it.
> Hope you can understand me , my English is not good.
> Regards,
> Chong
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> You can't do it during the shutdown process as you may not be notified,
>> if it is a quick one, there is an OS shut down or crash.
>> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
>> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
>> before you send the mail. This gives the various MAPI components time to
>> be loaded by SQL Agent before you start to throw work their way.
>> If the SQL Server is really critical, it is best to get an external
>> monitoring tool to monitor the OS and SQL Server. Self monitoring on
>> software has its problems...It can't report on itself very well as it
>> may not be in a state to monitor itself.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Jack" <chongh.hc@.gmail.com> wrote in message
>> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> Is it possible to config SQL mail send out a message when machine reboot
>> or SQL server shutdown?
>> Thanks,
>> Jack
>>
>

Mail

Greetings !
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.If outlook is a permissable client then you can install it. Just configure the ID that SQL is running under has an email account. Make it the default mail account.
Log into the server as the SQL I
After you have mail configured and can send email from the ID the
Configure your SQL MAil settings
Then reboot
After the reboot test it with an xp_sendmail script
Then you can configure your operators
Jeff Dunca
MCDBA, MCSE+I|||If you can "talk" to an SMPT server on your network this might be a good =solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
-- Keith
"Duke" <duke@.hotmail.com> wrote in message =news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> > I want to receive mail notification from backup job on SQL Server =outside of
> my company.
> Everything works when I have Exchange Server.
> > But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =it ?
> > Platfom Sql Server 2000 on Windows 2000 Server.
> > Thanks in advance
> > Gj.
> >|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>

Mail

Greetings !
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.
If outlook is a permissable client then you can install it. Just configure the ID that SQL is running under has an email account. Make it the default mail account.
Log into the server as the SQL ID
After you have mail configured and can send email from the ID then
Configure your SQL MAil settings.
Then reboot.
After the reboot test it with an xp_sendmail script.
Then you can configure your operators.
Jeff Duncan
MCDBA, MCSE+I
|||If you can "talk" to an SMPT server on your network this might be a good =
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--=20
Keith
"Duke" <duke@.hotmail.com> wrote in message =
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
>=20
> I want to receive mail notification from backup job on SQL Server =
outside of
> my company.
> Everything works when I have Exchange Server.
>=20
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =
it ?
>=20
> Platfom Sql Server 2000 on Windows 2000 Server.
>=20
> Thanks in advance
>=20
> Gj.
>=20
>
|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>

Mail

Greetings !
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.If outlook is a permissable client then you can install it. Just configure
the ID that SQL is running under has an email account. Make it the default
mail account.
Log into the server as the SQL ID
After you have mail configured and can send email from the ID then
Configure your SQL MAil settings.
Then reboot.
After the reboot test it with an xp_sendmail script.
Then you can configure your operators.
Jeff Duncan
MCDBA, MCSE+I|||If you can "talk" to an SMPT server on your network this might be a good =
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--=20
Keith
"Duke" <duke@.hotmail.com> wrote in message =
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
>=20
> I want to receive mail notification from backup job on SQL Server =
outside of
> my company.
> Everything works when I have Exchange Server.
>=20
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =
it ?
>=20
> Platfom Sql Server 2000 on Windows 2000 Server.
>=20
> Thanks in advance
>=20
> Gj.
>=20
>|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>