HOW-TO: SCHEDULE A JOB OF EXECUTING A DTS PACKAGE FROM WITHIN VB6Locked
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.
Fernando (Wanna be Visual Programmer)