Library tutorials & articles
SQL Distributed Management Objects Part 2
- Introduction
- The Code
- The Job Steps
- The Job Schedule
- Tidying Up
Introduction
|
There is a difference in SQLOLE and SQLDMO, SQLOLE.DLL library comes with SQL Server 6.5 while SQLDMO.DLL library comes with SQL Server 7.0. You will have to include the correct reference to the library, In case of this article, add the reference to the SQLDMO.DLL reference. |
More enhancements are made in the new component, the new component is capable
of deleting the task automatically once the task has been accomplished. In the
previous version, the task once created has to be removed manually by executing
a method called as RemoveTask but there is no need for such method
in the new component as it will delete the task upon successful completion. Furthermore,
earlier the task was executed each time a specific date was reached but now the
task will execute only once at a specific date the user will supply to the component.
Also, we have demonstrated how to add two steps in the same job. In the previous
article the job consisted of only one step but the new tasks created with the
new component shall consist of more than one job step, that is, user can accomplish
more than one job within the same task.
Related articles
Related discussion
-
dtPicker date format query
by konikula (1 replies)
-
MS Access in 3 different language
by buvanasubi (1 replies)
-
copying access DB to SQL DB
by Lufuno (0 replies)
-
How to receive data in web server sending from GPRS modem
by ashok.infotech (0 replies)
-
How to Databind PictureBox to database
by amazingpeople (0 replies)
Related podcasts
-
Stack Overflow: Podcast #28
This is the twenty-eighth episode of the StackOverflow podcast, where Joel and Jeff discuss Windows Azure, SQL Server 2008 full text search, Bayesian filtering, porn detection, and project management — among other things. Jeff met the inestimable Joey DeVilla aka Accordion Guy...
Related jobs
-
Microsoft Dynamics CRM Technical Consultant
in Netherlands (€50K-€90K per annum) -
Software Architect
in n/a (€45K-€70K per annum) -
Microsoft .Net Architect
in AMSTERDAM (€50K-€90K per annum) -
.net developer
in Rijswijk (€2K-€4K per annum)
Events coming up
-
Jun
16
Code Generation 2009
Cambridge, United Kingdom
A developer event with a practical focus on helping people get to grips with code generation tools and technologies.
This thread is for discussions of SQL Distributed Management Objects Part 2.