Discussion Locked

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

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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)

2 replies

by tony hopkinson

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.

This discussion is closed to new replies.