Timer Job stuck

  • 29 April 2021
  • 1 reply
  • 16 views

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?


1 reply

Userlevel 5
Badge +17
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

Reply