How to assign more Operators to a Job failure alert ?

Hello,
I'm using SQL Server 2000 and have defined 3 Operators that need to receive
alerts from shecduled jobs.
We have chosen to go with 'Net Send' type of alert.
Inside each scheduled job, under Notifications Tab, it doesn't give me a
choice to add more operators upon failure of this job, nor does it allow me
to run a script (a batch file that I would include Net send commands to 3
Operators).
Is there a quick way to resolve this without installing Notifications
Services ?
Thanks,
Sam.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1We use netsend operators at work but rather than using seperate mail
accounts, we use a mail group, that way you can send to more users.
"Sameer via SQLMonster.com" <u4996@.uwe> wrote in message
news:5d00a065a9839@.uwe...
> Hello,
> I'm using SQL Server 2000 and have defined 3 Operators that need to
receive
> alerts from shecduled jobs.
> We have chosen to go with 'Net Send' type of alert.
> Inside each scheduled job, under Notifications Tab, it doesn't give me a
> choice to add more operators upon failure of this job, nor does it allow
me
> to run a script (a batch file that I would include Net send commands to 3
> Operators).
> Is there a quick way to resolve this without installing Notifications
> Services ?
> Thanks,
> Sam.
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||Where and how do you create the Mail Group ?
--
Message posted via http://www.sqlmonster.com|||In your mail server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"spremji via SQLMonster.com" <u4996@.uwe> wrote in message news:5d036a522f9fe@.uwe...
> Where and how do you create the Mail Group ?
> --
> Message posted via http://www.sqlmonster.com|||Would that mean that I have to setup MAPI on SQL Server for it to detect Mail
Groups ?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||The built-in mail feature of SQL Server 2000 only supports MAPI. There are some workarounds
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), but we finally got SMTP support in 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"spremji via SQLMonster.com" <u4996@.uwe> wrote in message news:5d0e98b1e5179@.uwe...
> Would that mean that I have to setup MAPI on SQL Server for it to detect Mail
> Groups ?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||The reason we went with Net Send was to avoid MAPI setup on the server. But I
guess, I'll develop custom-code to handle this.
Thanks for your advises. I appreciate it :-)
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1sql

How to alert via email when Agent records errors/warning in log?

We are in on SQL2000 and our SQL Server Agent started to receive errors for
Mail Profile not available. It wasn't until we looked at the agent error log
we saw the problem.
Is there any way to report the SQL Server Agent Warnings/Errors via email or
alert as a pro-active stance?
Hi
Instead of using alerts you could have steps that send emails, to avoid mapi
you can use SMTP see http://www.sqldev.net/xp/xpsmtp.htm. The sending of the
email can be determined by the jobs workflow if necessary.
If you are looking for a product to monitor your server then you may want to
check out MOM.
John
"ssciarrino" wrote:

> We are in on SQL2000 and our SQL Server Agent started to receive errors for
> Mail Profile not available. It wasn't until we looked at the agent error log
> we saw the problem.
> Is there any way to report the SQL Server Agent Warnings/Errors via email or
> alert as a pro-active stance?

How to alert via email when Agent records errors/warning in log?

We are in on SQL2000 and our SQL Server Agent started to receive errors for
Mail Profile not available. It wasn't until we looked at the agent error lo
g
we saw the problem.
Is there any way to report the SQL Server Agent Warnings/Errors via email or
alert as a pro-active stance?Hi
Instead of using alerts you could have steps that send emails, to avoid mapi
you can use SMTP see http://www.sqldev.net/xp/xpsmtp.htm. The sending of the
email can be determined by the jobs workflow if necessary.
If you are looking for a product to monitor your server then you may want to
check out MOM.
John
"ssciarrino" wrote:

> We are in on SQL2000 and our SQL Server Agent started to receive errors fo
r
> Mail Profile not available. It wasn't until we looked at the agent error
log
> we saw the problem.
> Is there any way to report the SQL Server Agent Warnings/Errors via email
or
> alert as a pro-active stance?

How to alert via email when Agent records errors/warning in log?

We are in on SQL2000 and our SQL Server Agent started to receive errors for
Mail Profile not available. It wasn't until we looked at the agent error log
we saw the problem.
Is there any way to report the SQL Server Agent Warnings/Errors via email or
alert as a pro-active stance?Hi
Instead of using alerts you could have steps that send emails, to avoid mapi
you can use SMTP see http://www.sqldev.net/xp/xpsmtp.htm. The sending of the
email can be determined by the jobs workflow if necessary.
If you are looking for a product to monitor your server then you may want to
check out MOM.
John
"ssciarrino" wrote:
> We are in on SQL2000 and our SQL Server Agent started to receive errors for
> Mail Profile not available. It wasn't until we looked at the agent error log
> we saw the problem.
> Is there any way to report the SQL Server Agent Warnings/Errors via email or
> alert as a pro-active stance?sql