Wednesday, January 22, 2025

Business Central - SQL job to Auto Restart Error jobs in job queue

 update [Cronus$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

  set Status = 0

  where [Object ID to Run]<> 260 and [Recurring Job] = 1 and Status = 2 and [User ID]= 'Cronus\Administrator'

-------------------------------------------

Job Queue: codeunit 99001469

Parameter string: LSRSCHEDULER NAS_MISC,LOG=1, REPEAT=0


-----------------------------------------------

--Clear excessive197 jobs


delete FROM [Cronus].[dbo].[Cronus$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

  where [Object ID to Run] = 197

No comments:

Post a Comment