Community forum

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

Matthew Mitchell
We have dozens of SQL jobs that write SQL data to files and by the time we go live with VisualCron will have hundreds. Some of them use stored procedures while others use SQL commands/text. Once in a while we need to stop one of these jobs because it is long-running or something else is happening where we do not want the job to complete.

If we try to stop the job using the Stop Job button (or right-click menu or Task Manager tool or Running Jobs tool), either nothing happens for several minutes or the server crashes.

We have tried different approaches such as stopping the SQL task instead of the whole job, pausing the job and task, resetting the job, deactivating the job, etc. Most of the time the server doesn't crash, but it happens enough to make us concerned.

What is a clean way to stop a SQL task/job? Once you click Stop Job, should that button be greyed out (is there any indication that the job is attempting to stop)?
Forum information
Scroll to Top