Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Batch Script to Clear Hung Execution Packages


Expert



This KB will outline how to create a Batch Script to clear out hung Jet Data Manager execution packages.

  1. First open Task Scheduler on the server where the Jet Data Manager is installed. Then create a new task called "Clear Hung Executions".

  2. We recommend this task be run daily after your scheduled executions have completed.If you run your execution packages more frequently, you can increase the frequency of this task as well.

  3. Select the "Start a program" option in the Action tab.

  4. Next you will need to create two different files in Notepad. The first file will be a .bat file that will call to the second file to run a SQL statement.

    Open Notepad and type the following: sqlcmd -S databaseserver -i "C:\Jet\ClearHungExecutions.sql"

    NOTE: Replace databaseserver with the name of the SQL Server where the projectRepository database is being stored.

    Save this file on the C drive in a folder called Jet and call it ClearHungExecutions.bat



    Open a new Notepad and type the following: UPDATE [projectRepository].[dbo].[ScheduleJobs] SET [ProcessId] = '' WHERE [ProcessId] != ''

    Save this file in the same location and name it ClearHungExecutions.sql

  5. Now go back to Task Scheduler and point to the .bat file we created.

  6. Review and click Finish.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments