Check SQL job running

[chapm4]

I have a request to check if a sql job is running or not within my vb app. The user actually requested a dashboard item that checks say every so many seconds and places a yes or no. I cannot find any info on dashboard stuff.

I have thought about using fileSystemChecker to check for the precence of the last file. Is this a good idea, or does someone have a better suggestion?

 

[scking]

If you are executing the sql directly then I know of no way other than somehow using the Windows API to check the thread process. If you are using a procedure you could set the dashboard item to 'Processing' and following the execute you could set it to 'Complete'. Or, if you sql job uses VBA code to process then it becomes trivial to determine the status, and even what record of how many records are processing. The difficulty would be to determine how to determine whether the dashboard is displayed and how to update the controls on the dashboard.
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------