Date: 10/27/06 (SQL Server)    Keywords: sql

I have been working on a SQL Server 2000 project to generate/transform data so that we can upload it from our data warehouse [corporate-level] into another data warehouse [enterprise-level]. One of the big requirements for this project is that it's reliable, we are notified of errors, and that we can measure our processes. Does anybody know of any good online resources/articles that specifically discuss:

Measuring/monitoring SQL Server jobs?

Tips for writing robust stored procedures?


Other thoughts/ideas/discussion are welcome as well.

Source: http://community.livejournal.com/sqlserver/53745.html