I want VC to start a job in SQL 2000 and monitor it.
If it runs over 6 hrs, I want VC to kill the job and alert me.
If it completes successfully in under 6 hrs, I want VC to alert me.

So far, VC will start the job and then consider the task complete, alerting me immediately of a successful job.

I don't want to move the job out of SQL as I need the logging.

Ideas?

The main question is how you can monitor a SQL Job? Is there any query for that?

---

I don't know if there is a query for that.

Your suggestion appears to be that VC should run a task that runs a sql query that monitors the sql job. If this is so, the implication is that VC does not have a way to monitor a running sql job. Is this correct?

If so, do you have any other suggestions on VC capabilites to perform this task?

If I remember correctly you can use the DTS/SSIS Task. That only works locally but I think it will wait for completion.

---

This did indeed work.

I have also found that runnign batch files remotely using the remote execute causes VC to start the job, then consider it complete. Runnign them usign the local esecute, it monitors the job.