• State Not Answered
  • Locked Locked
  • Replies 12 replies
  • Subscribers 94 subscribers
  • Views 9469 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Job server is not processing anything

ruchita.mantri
over 5 years ago

Hi,

We have configured job server remotely and updated jobservice.cfg file. And we added the entry of job server in Designer. Service of this job server is running properly but jobs are not getting executed by this job server. We restarted the service, server but nothing is working out. Please guide to resolve this issue. Thank you.

  • 0 over 5 years ago

    You should check, if there are any disabled triggers, because that can affect negatively the behavior of the job server.

    Another problem can occur, if you have done your job server configuration before you have set the service account under which the job server will be running and executed. Because the DB connection settings will be stored in the registry for the user that is currently set for running the service. This can be fixed by re-configuring the DB connection settings via the JobServiceConfigurator for the new service account.

    You should have a look into the DialogJournal, if there are addintional informations regarding your Problem. You can check it via JobQueue or with the following SQL statement:

    SELECT MessageString, MessageDate FROM DialogJournal
	WHERE
		MessageType = N'E'
	ORDER BY MessageDate DESC

  • 0 over 5 years ago in reply to ruchita.mantri

    check if autoupdate is enabled but the update server is not defined or not processing

    -- is auto update enabled
select Value, IsEnabledResulting from DialogConfigParm where Fullpath = 'Common\Autoupdate'

-- does file content look okay
select len(FileContent), len(HashValue) from QBMFileRevision where UID_QBMFileRevision = 'QBM-74EC03CD5A0D2B334D197DBD5158A598'

-- check if queue is in autoupdate and there is a update server
select s.Ident_Server, s.IsInSoftwareUpdate, s.IsNoAutoupdate, s.IsJobServiceDisabled, sign(len(t.UID_QBMServerTag)) as IsUpdateQueue from QBMServer s
	left outer join QBMServerHasServerTag t on s.UID_QBMServer = t.UID_QBMServer and t.UID_QBMServerTag = 'QBM-ST-Is07'
	where IsQBMServiceInstalled = 1