Job are not being picked up from the pending jobs table?

• Check if the service account in security has all access rights in the application. 
  
  
• Check how long each step of the job is taking by creating a Query. Select * From Log WHERE [Formatted Message], for example: '% Insert Job ID Here %'.
  
  
• Check if the Service Broker is enabled. (Not applicable for Arkieva Version 5.1 and up.)
  
  
• Check the Event Viewer for possible shut down of service during time of job execution.
  
  
• Check to see if the Job Service Version is the same as the database.
  
  

• Related Articles

• Run LP Remotely job not working?

  You need elevated privileges to execute the Create Job and Run Jobs. If these elevated privileges are not set, you will not be able to run jobs remotely in the LP. 

• I cannot run or create jobs?

  User is trying to regenerate the system model but the dialog is stuck at step 4: trying to create the job to recreate index views. Also issue produces an error message when trying to execute stored procedure such as RecreateIndexedViews with messages ...

• Best Method is not showing when run as a job?

  The reason Best Method is not showing when run by a Job is because of the service account. Give the service account full access to all data in security, then try running the job again. 

• How do I find job duration in minutes?

  The below script shows the duration in minutes based on dbo.Log for a given job (replace the parameter below by Job.Name). EXEC PrsDropObject #JobLog SELECT * INTO #JobLog FROM Log WHERE Category = ‘RunJob’ AND Timestamp > DATEADD(month, -6, ...

• Cannot access the same attributes in Quick and Table editor?

  When having roles in the system model, you can access the role’s attributes in a Quick report but not in the Table Editor. Since the Table Editor only queries directly on a table, it is not possible to access the attributes of a role in table editor.