Software·43,783 discussions

HOW-TO: SCHEDULE A JOB 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

Reply To: HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

In reply to HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

generating an active x ctrl must help

Reply To: HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

In reply to Reply To: HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

Poster rated this answer.

Reply To: HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

In reply to HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

generating an active x ctrl must help

Reply To: HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

In reply to Reply To: HOW-TO: SCHEDULE A JOB FROM WITHIN VB6

Poster rated this answer.

[Author]

Replies