Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-15 : 08:45:21
|
| melissa writes "Hi, Has anyone setup alert forwarding with any success in sql 2000? I haveconfigured a master and target server but can't seem to get beyond that.And I am having great problems find any documentation on alertsforwarding.I want to setup alert forwarding to harness the sqlmail functioning onthe master server. Is this a possibility. When the alerts fires on atarget server, I want the master server to be notified and send out anemail. When you are setting up alert forwarding, do you set up the alertlocally? Or on the master server? I can't seem to find any answers tothis! I am running sql 2000 and win 2000. Thanks,Melissa" |
|
|
Spyder
SQLTeam Author
75 Posts |
Posted - 2002-02-19 : 03:51:48
|
Are you getting any particular error messages? One thing to make sure of is on the target server, make sure you have "Forward events to a different server" enabled -- to do this, on the target server, go to the "Advanced" tab of SQL Server Agent Properties and then check the box for "Forward events to a different server". From there you can pick what kind of events you want to have forwarded. |
 |
|
|
mlierman
Starting Member
1 Post |
Posted - 2002-02-19 : 09:41:45
|
| I have this option set up. But I am unsure of where to setup the jobs. Because when I look at the master server. The jobs are divided into local and master jobs. The local jobs on the local servers do not show up. Is this correct? Or should I be setting them up under local jobs on the master server? |
|
|
|
|
|
|
Alert Forwarding on 2000