Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion

Locked

HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

By fsanchez ·
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)

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums