Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


MikeBoBo
2008-09-09T20:16:35Z
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?
Sponsor
Forum information
Support
2008-09-09T22:51:55Z
The main question is how you can monitor a SQL Job? Is there any query for that?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
MikeBoBo
2008-09-10T00:47:18Z
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?
Support
2008-09-10T09:14:10Z
If I remember correctly you can use the DTS/SSIS Task. That only works locally but I think it will wait for completion.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
MikeBoBo
2008-09-12T20:05:59Z
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.
Scroll to Top