Generate an alert from a stored procedure or VB script

[Adam White]

Hi

We are currently using CA Unicenter for system management. It includes a
command-line tool called "cawto.exe" that can send a message to the Unicenter
console that can then trigger an alert. We put this exe on our sql servers
and call it from numerous custom stored procedures to alert on failed jobs,
etc.

Is there a way to generate an event on MOM by running a stored procedure or
VB script on a managed SQL server?

Thanks
Adam

[Lars Norman Søndergaard]

Hi Adam,

You could use one of many commandline tools that writes your alert into the
eventlog and then collect the information from a custom MOM rule.

Alternatively write the alerts to a database on your SQL server and have a
custom MOM script read these and create alerts.

Thanks
Lars Norman Søndergaard

Post by Adam White
Hi
We are currently using CA Unicenter for system management. It includes a
command-line tool called "cawto.exe" that can send a message to the Unicenter
console that can then trigger an alert. We put this exe on our sql servers
and call it from numerous custom stored procedures to alert on failed jobs,
etc.
Is there a way to generate an event on MOM by running a stored procedure or
VB script on a managed SQL server?
Thanks
Adam

[Bryan]

Lars,

I'm looking to do something very similar, I working on trying to figure out
how to monitor an application that writes error information to various SQL
Server tables. Would I have to write a VBScript to run a series of queries
and then pass the results to a Rule using the Ops Manager 2007 APIs?


Bryan

Post by Lars Norman Søndergaard
Hi Adam,
You could use one of many commandline tools that writes your alert into the
eventlog and then collect the information from a custom MOM rule.
Alternatively write the alerts to a database on your SQL server and have a
custom MOM script read these and create alerts.
Thanks
Lars Norman Søndergaard

Post by Adam White
Hi
We are currently using CA Unicenter for system management. It includes a
command-line tool called "cawto.exe" that can send a message to the Unicenter
console that can then trigger an alert. We put this exe on our sql servers
and call it from numerous custom stored procedures to alert on failed jobs,
etc.
Is there a way to generate an event on MOM by running a stored procedure or
VB script on a managed SQL server?
Thanks
Adam

[Anders Bengtsson]

Hi bryan,

Yes will need a script to read inside databases and tables. You can configure
your SQL server to log to local event viewer and then collect that with Ops
Mgr and MOM.


-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


b> Lars,
b>
b> I'm looking to do something very similar, I working on trying to
b> figure out how to monitor an application that writes error
b> information to various SQL Server tables. Would I have to write a
b> VBScript to run a series of queries and then pass the results to a
b> Rule using the Ops Manager 2007 APIs?
b>
b> Bryan
b>
b> "Lars Norman Søndergaard" wrote:
b>

Post by Lars Norman Søndergaard
Hi Adam,
You could use one of many commandline tools that writes your alert
into the eventlog and then collect the information from a custom MOM
rule.
Alternatively write the alerts to a database on your SQL server and
have a custom MOM script read these and create alerts.
Thanks
Lars Norman Søndergaard

Post by Adam White
Hi
We are currently using CA Unicenter for system management. It includes a
command-line tool called "cawto.exe" that can send a message to the Unicenter
console that can then trigger an alert. We put this exe on our sql servers
and call it from numerous custom stored procedures to alert on
failed
jobs,
etc.
Is there a way to generate an event on MOM by running a stored
procedure
or
VB script on a managed SQL server?
Thanks
Ada