This KB will outline how to create a Batch Script to clear out hung Jet Data Manager 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 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
Now go back to Task Scheduler and point to the .bat file we created.
Review and click Finish.