Unanswered: Sql Server Scheduler -- quesion please
I have a table called FOO that has 1 column called BooleanRunning
There is only 1 record in there, and it is either 'YES' or 'NO'.
I would like SQL Server Scheduler to do the following
Check first record of table Foo. If BooleanRunning='YES' then fail. If BooleanRunning='NO then Step is SUCCESSFUL, GO TO STEP 2
Execute my Vb Program.
HOW DO I DO STEP 1?
My VB program sets BooleanRunning to "YES" at the beginning and sets it to "NO" at the end. (I could have the VB program check BooleanRunning ="yes" then quit, but that still means I would have to start a second instance of the vb program which I do not want).
Why do you need to schedule the vb app as a job - why not just handle the logic within the vb app ? You can also set it up as a windows scheduled task and have the vb app test to see if an instance of it is already loaded. What does the vb app actually do and why do you have to keep invoking it ?