DB Server monitoring

[Zaffryn]

Good day all,

at work we need to monitor several sql servers and we would like to build a software for monitoring SQL server agent job activity. Could anyone point me in the right direction ( web tutorial, book etc.) to where I can find the info to start doing this application.

Any help would be welcome

thank you

 

[jmcilhinney]

SMO provides an object model for automating SQL Server. It is the managed replacement for SQL DMO that died with SQL Server 2000. You should be able to hook into SQL Server Agent that way via the Microsoft.SqlServer.Management.Smo.Agent namespace.

SQL Server Management Objects (SMO) Programming Guide