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.