HI,
i have having issue with stuck nintex Scheduler timer job at 0%. the timer job is installed on Web front end and i have done iisrest, reboot the machine, restarted SharePo
Can anyone please advise?
Userlevel 6
+22
Hi,
The job actually has two functions.
1. is to check the dbo.workflowSchedule table for scheduled workflows to run and the secondary but little known function is to check the dbo.WorkflowLog table and delete any logs that are older than 5 days. The dbo.WorkflowLog table is uses when verbose logging for Nintex has been used. If this table has a lot of rows in it this could cause the scheduler job to get stuck. If the dbo.workflowSchedule also has a lot of rows in it this could also cause the job to get stuck. If the dbo.workflowSchedule does have a lot of rows in it delete any row that has a next run date of 9999-12-31 23:59:59.997
More information can be found here:
https://community.nintex.com/t5/Best-Practices/The-Nintex-Workflow-Scheduler-Job/ta-p/86107
The job actually has two functions.
1. is to check the dbo.workflowSchedule table for scheduled workflows to run and the secondary but little known function is to check the dbo.WorkflowLog table and delete any logs that are older than 5 days. The dbo.WorkflowLog table is uses when verbose logging for Nintex has been used. If this table has a lot of rows in it this could cause the scheduler job to get stuck. If the dbo.workflowSchedule also has a lot of rows in it this could also cause the job to get stuck. If the dbo.workflowSchedule does have a lot of rows in it delete any row that has a next run date of 9999-12-31 23:59:59.997
More information can be found here:
https://community.nintex.com/t5/Best-Practices/The-Nintex-Workflow-Scheduler-Job/ta-p/86107
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.