DTS Active Jobs

DTS Active Jobs

Post by Morgan Fear » Tue, 07 Dec 1999 04:00:00



If I have a job scheduled on the server, is it possible to poll the server,
via SQL-DMO, or the DTS PackageObject Library in VB, to see if a package is
running?
I wish to enable a "refresh on demand" type option, but I don't want to send
a similar DTS request for a package that is running, and impatience has the
best of them.

Thanks,
Morgan

 
 
 

1. DTS Active Jobs

If I have a job scheduled on the server, is it possible to poll the server,
via SQL-DMO, or the DTS PackageObject Library in VB, to see if a package is
running?
I wish to enable a "refresh on demand" type option, but I don't want to send
a similar DTS request for a package that is running, and impatience has the
best of them.

Thanks,
Morgan

2. SQL Files

3. Multi-server jobs targeting an Active-Active Cluster

4. DATACOMBO: errors using the .FIND

5. DTS +Active VB Script +Active x scripting host error (BETA3)

6. Posting a string with both kinds of quotes in it

7. DTS in an Active/Active config.

8. SQL server 2000 slow to process analysis server after sqlsp3

9. JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS

10. active/passive to active/active model

11. Active/Passive change to be Active/Active

12. active/active or active/passive?

13. Active/Active vs Active/Passive Documentation