Sometimes, JobTraQ’s database queries time out because of other activity that is slowing down the database server. When this happens, JobTraQ software can gather information about the other activity on the server so that our support team can analyze it for problems. However, it cannot gather this information unless it is given access to the database server’s state. To give JobTraQ permission to gather this information, follow these steps:

  • Open SQL Server Management Studio and connect to your database server as a server administrator.
  • Find the name of the JobTraQ database admin account. This is usually JobTraQ_Admin.
  • Open a new query window.
  • Run this command: GRANT VIEW SERVER STATE TO JobTraQ_Admin
    (replace JobTraQ_Admin with the correct username)

Once this permission is granted, you can close SQL Server Management Studio. The next time a timeout error happens, JobTraQ software will gather the information that it needs and send it to our support team.

Take Control of Your Business Processes

With JobTraQ your business processes are controlled, measured, and continuously improved. Allowing you and your organization to enjoy new levels of success. What are you waiting for?

Request a Demo or Call Us +1.866.640.CODE (2633)