Stuck Job hanging in monitoring view
Last Updated: Oct 12, 2017 08:40PM CEST
This will not allow this job to be reported. The job will still run on regular scheduled intervals regardless if there is an actively hung job in the Monitoring view.
Occasionally there will be times when a job will get stuck in the actice Monitoring screen and is unable to be cleared through cancelling the job.
Steps to Resolution
Before starting, make sure there are no active jobs set to run during this maintenance.
Make sure the NovaBACKUP Datacenter GUI is closed.
Open a command box and change directory to
For example with the default install directory
cd C:\Program Files\novastor\DataCenter\db-derby\bin\tools
Then set the 2 environment variables DERBY_HOME and JAVA_HOME with the following commands:
set DERBY_HOME=C:\Program Files\novastor\DataCenter\db-derby
set JAVA_HOME=C:\Program Files\novastor\DataCenter\jre
Now you can start the Derby access tool ij:
Type ij.bat at the prompt
At the ij> prompt, type the connection string
At this point we are going to empty the “ACTIVE_JOB” table by executing the following sql query
DELETE FROM ACTIVE_JOB;
Open the Datacenter GUI, and you will now see the hung job is no longer in the Monitoring view.