Introduction
Before starting, let's shed some light on the SQL Distributed Management Objects
(SQL-DMO). ASP gets its functionality by using server components. In ASP we can
combine scripts, HTML, and reusable server components to create scalable Web
applications. These server-side ActiveX components can be developed in many languages,
such as VC++, Java, and Visual Basic (VB).
|
Note
This tutorial uses the SQL-OLE version of SQL-DMO, which was used in SQL
Server 6.5 and earlier. The second part to this
tutorial uses code compatible with the later versions of SQL Server
|
I have selected VB to develop a component that will be used in ASP scripts
to harness the power of SQL-DMO. SQL-DMOs are OLE automation-compatible COM objects.
These objects and a set of properties and methods are used to write programs
to administer multiple SQL Servers distributed across a network. Also, SQL-DMO
is the foundation of SQL Enterprise Manager. In fact, SQL-DMO is a very powerful
object model of SQL Server management. The obvious advantage of using a component
encompassing SQL-DMO functionality is that you can manage your SQL Server from
anywhere in the world.
Although, SQL-DMO is a complete set of objects and methods to manage the SQL
Server remotely, in this article, we will only see how to add and remove SQL
tasks in the Task Scheduler. I decided to write this article because I couldn't
find a good article about using SQL-DMO in ASP. The article, which details how
to leverage VB to create the ASP component, uses the following technologies:
- Visual Basic 6
- SQL Server