-
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"
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.
Comments