Automating Data Warehouse Tasks
There are numerous tasks involved in administering and maintaining a data warehouse. Many of these tasks can be automated using a variety of tools available in Microsoft® SQL Server™ 2000. Appropriate tasks can be scheduled for periodic accomplishment.
A data warehouse must be updated on a periodic basis to incorporate new data from ongoing business operations. You can combine various SQL Server 2000 processing features and methods to define jobs that perform the data extractions. You can schedule the periodic execution of such jobs and provide automatic notification of job completion and status.
In addition to the built-in tools, SQL Server 2000 provides a number of programming object models and interfaces that can be used to create custom applications that perform administrative tasks. You can use programming languages such as C/C++, Microsoft Visual Basic®, or scripting to create these applications. For more information, see Building SQL Server Applications Overview and other topics in the Building SQL Server Applications section of Books Online.
See Also
Automating Administrative Tasks