Web Development

General discussion

Gravatar
0 Votes
Locked

HOW-TO: SCHEDULE A JOB OF EXECUTING A DTS PACKAGE 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

gravatar
Collapse -

Can't remember the exact syntax

by Tony Hopkinson In reply to HOW-TO: SCHEDULE A JOB OF ...

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.

gravatar
Collapse -

I am also looking for the same solution

by chandrajit.samanta In reply to Can't remember the exact ...

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

Back to Web Development Forum

Start or search

Related Discussions

Related Forums