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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  querying system tbls. for DBA reporting

Author  Topic  LeoC Starting Member 37 Posts Posted - 2004-11-10 : 16:02:41 We have bought BMC's solutions for Oracle and SQL server, but for some reason the SQL server code is not working right and it's been under vendor investigation too long already. I thought I'll my own sp. to reflect tasks/jobs status, timeline, etc... I took a snapshot with 'profiler' to see the queries that were issued when I checked tasks status via Enterprise Manager. But I'm wondering if someone in this handy Forum has already done/written a similar code so I don't have to spend too much time in this feature? Any piece would help... thxs. lec. lec.