Batch Script to Clear Hung Execution Packages

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

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.

Select the Start a program option in the Action tab.

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

Open Notepad and type the following:

sqlcmd -S databaseserver -i "C:\Jet\ClearHungExecutions.sql"

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

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

Review and click Finish.