Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

HOW-TO: SCHEDULE A JOB OF EXECUTING A DTS PACKAGE FROM WITHIN VB6

Locked

Hi,
I have recently created a VB6 application that provides a list of available DTS Packages on the SQL Server 2000 database to the user and allows them to execute the package.

Although the function works fine, there is a need to have the task schedule to execute at a later time because when the task is executed, the control is not returned to the application until task is completed.

I am interested in knowing if it is possible to use and/or program the execution of the DTS Package from within VB6 using the SQL Server 2000 job scheduler? If so, is there any available sample code that I can review to assist me in this challenge.

Your comments and/or assistant is greatly appreciated.

Regards
Fernando (Wanna be Visual Programmer)

Topic

Can’t remember the exact syntax

In reply to HOW-TO: SCHEDULE A JOB OF EXECUTING A DTS PACKAGE FROM WITHIN VB6

But MS SQL has a scheduler, it uses the MSDB database. All you have to do is insert/update and entry in it. There are stored procedures already in there to do that. Google or SQL help should get you on your way.

I am also looking for the same solution

In reply to Can’t remember the exact syntax

How to schedule DTS Packages from ASP.NET C# application?
Any body can reply directly to chandrajit.samanta@gmail.com

[Author]

Replies