How can I find out if a specified MS SQL job is running or not

[pmscraiova]

Hello,
How can I find out if a specified MS SQL job is running or not?
Best regards,
Eugen

 

[Mike Gagnon]

pmscraiova

Is this a FoxPro question?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[pmscraiova]

Mike, I am sure that this is not a "pure" FoxPro question, but I think that is possible like somebody who used Visual FoxPro + MS SQL Server had the same problem. Maybe, somebody can help me with some advices. Actually, I have an application written in Visual FoxPro 7.0 which uses a MS SQL databases. I want to deny access to SQL server when there are some jobs in progress (I mean a replication job).
Thank you,
Eugen

 

[Mike Lewis]

Eugen,

Although you might get an answer here, I suggest you also post the question in an appropriate SQL Server forum. Be sure to specify that you are talking about a replication job, and just say that you want to programmatically test to see of the job is in progress from a client application (not necessarily VFP).

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[pmscraiova]

Thank you, Mike. I'll try it. I am a beginner into SQL server and thus I posted my question to a Visual FoxPro forum…
Thank’s again.
Eugen