Hi,
Just a post in order to expose a solution in order to force the starting/stopping of a running job.
Force the job’s starting via DQL:
- Execute the following query:
1UPDATEdm_job OBJECTSsetrun_now=true,seta_next_invocation=DATE(NOW)WHEREobject_name ='[job_name]'; - Check the log and the automatically setting to initial value for the next invocation date by AGENT_EXEC process depending on the scheduling parameters of job :
1SELECTr_object_id, a_last_invocation, run_now, a_next_invocationfromdm_jobWHEREobject_name ='[job_name]';2## LOGS3SELECT*FROMdm_sysobjectWHEREfolder('/Temp/Jobs/[job_name]')ORDERBYr_creation_dateDESC;
Force the job’s stopping:
- Get the process id, by running the DQL (dm_job.a_last_process_id):
01SELECTr_object_id, a_last_invocation, a_last_process_id, a_last_completion, a_special_app, r_lock_date, r_lock_machine, is_inactive, run_now, a_next_invocation, a_current_status, a_last_return_code, i_is_reference, i_is_replica dm_jobwhereobject_name='[JOB_NAME]';020304r_object_id = 080xxxxxxxxxxxx905a_last_invocation = 01/01/2016 10:00:5606a_last_process_id = 897607a_last_completion = nulldate08a_special_app = agentexec09r_lock_date = 01/01/2016 10:00:5210r_lock_machine = MYSERVERDCTMCS11is_inactive = 112run_now = 013a_next_invocation = 02/01/2016 09:55:4214a_current_status = STARTED15a_last_return_code = 016i_is_reference = 017i_is_replica = 0 - Kill the process corresponding via the process explorer (Example: In Windows Task Manager, the process name must be “dm_agent_exec.exe”) or with a command instructions (Windows: taskkill /pid 1234).
In some cases, the job goes on to be executed despite of process killing. The job is unlock and without application specified of locker:
This situation is precised in the “a_current_status” field.
+ “a_current_status” = “The job object indicated the job was in progress, but the job was not actually running. It is likely that the dm_agent_exec utility was stopped while the job was in progress.”.
+ “r_lock_date” = nulldate
+ “r_lock_machine” = nullstring
+ “a_special_app” = ”
=> The unique solution is to restart the Java Server Method via the CMD (D:\Documentum\jboss7.1.1\server\stopMethodServer.cmd) OR Services Manager.Example of process’ stopping (https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.management/get-process?view=powershell-7):
01Windows PowerShell02Copyright (C)2016Microsoft Corporation. All rights reserved.0304PS C:\Users\useradmin> Get-Process -Id131230506Handles NPM(K) PM(K) WS(K) CPU(s) Id SI ProcessName07------- ------ ----- ----- ------ -- -- -----------081923232527121393285.77131230dm_agent_exec0910PS C:\Users\useradmin> Get-Process -Id13123| Stop-Process11PS C:\Users\useradmin> Get-Process -Id1312312Get-Process : Cannot find a process with the process identifier13123.13At line:1char:114+ Get-Process -Id1312315+ ~~~~~~~~~~~~~~~~~~~~~16+ CategoryInfo : ObjectNotFound: (13123:Int32) [Get-Process], ProcessCommandException17+ FullyQualifiedErrorId : NoProcessFoundForGivenId,Microsoft.PowerShell.Commands.GetProcessCommand1819PS C:\Users\useradmin> - Unlock the job via the API commands:
1dump,c,[JOB_OBJECT_ID]2unlock,c,[JOB_OBJECT_ID] - Reset some execution-related job’s fields via DQL query (application/launcher of job, current status, ):
1updatedm_job objectsseta_special_app='',seta_current_status='FAILED',setrun_now=FALSEwhereobject_name='[JOB_NAME]'; - The job is unlocked now and ready to be run again.
01SELECTr_object_id, a_last_invocation, a_last_process_id, a_last_completion, a_special_app, r_lock_date, r_lock_machine, is_inactive, run_now, a_next_invocation, a_current_status, a_last_return_code, i_is_reference, i_is_replica dm_jobwhereobject_name='[JOB_NAME]';020304r_object_id = 080xxxxxxxxxxxx905a_last_invocation = 01/01/2016 10:00:5606a_last_process_id = 897607a_last_completion = 01/01/2016 15:03:4808a_special_app =09r_lock_date = nulldate10r_lock_machine =11is_inactive = 112run_now = 013a_next_invocation = 02/01/2016 09:55:4214a_current_status = FAILED15a_last_return_code = 016i_is_reference = 017i_is_replica = 0 - Target server jobs:
01selectdistincttarget_serverfromdm_joborderby1;02....03target_server040506MY_DOCBASE_TEST.MYAPP986_MY_DOCBASE_TEST@MYAPP98607MY_DOCBASE_TEST.MY_DOCBASE_TEST.MY_DOCBASE_TEST@myapp98508MY_DOCBASE_TEST.MY_DOCBASE_TEST@MYAPP99809MY_DOCBASE_TEST.MY_DOCBASE_TEST@MYAPP98510MY_DOCBASE_TEST.MY_DOCBASE_TEST@myapp99811MY_DOCBASE_TEST.MY_DOCBASE_TEST@myapp98512MY_DOCBASE_TEST.myapp900_MY_DOCBASE_TEST@myapp90013MY_DOCBASE_TEST.myapp986_MY_DOCBASE_TEST@MYAPP98614MY_DOCBASE_TEST.myapp986_MY_DOCBASE_TEST@myapp98615MY_DOCBASE_TEST.myapp953_MY_DOCBASE_TEST@myapp953 - All jobs:
01selectr_object_id, method_name, is_inactive, inactivate_after_failurefromdm_joborderby2;02....03r_object_id method_name is_inactive inactivate_after_failure04080xxxxxxxx38b dm_ACLReplication 1 005080xxxxxxxx48f dm_AsynchronousWrite 1 006080xxxxxxxx31d dm_AuditMgt 0 007080xxxxxxxx334 dm_ConsistencyChecker 0 008080xxxxxxxx32d dm_ContentReplication 1 009080xxxxxxxx317 dm_ContentWarning 0 010080xxxxxxxx318 dm_DBWarning 1 011080xxxxxxxx330 dm_DMArchive 1 012080xxxxxxxx319 dm_DMClean 0 013080xxxxxxxx31a dm_DMFilescan 1 014080xxxxxxxx33f dm_DataDictionaryPublisher 0 015080xxxxxxxx32f dm_DistOperations 1 016080xxxxxxxx3fc dm_FTCreateEvents 1 017080xxxxxxxx3fe dm_FTIndexAgentBoot 1 018080xxxxxxxx3fd dm_FTStateOfIndex 1 019080xxxxxxxx388 dm_FederationCopy 1 020080xxxxxxxx387 dm_FederationExport 1 021080xxxxxxxx389 dm_FederationImport 1 022080xxxxxxxx38a dm_FederationStatus 1 023080xxxxxxxx386 dm_FederationUpdate 1 024080xxxxxxxx32e dm_FileReport 1 025080xxxxxxxx332 dm_GroupRename 1 026080xxxxxxxx44e dm_GwmClean 0 027080xxxxxxxx44d dm_GwmTask_Alert 0 028080xxxxxxxx38d dm_LDAPSynchronization 1 029080xxxxxxxx31b dm_LogPurge 0 030080xxxxxxxx341 dm_MoveContent 1 031080xxxxxxxx31e dm_QueueMgt 0 032080xxxxxxxx340 dm_RemoveExpiredRetnObjects 1 033080xxxxxxxx31f dm_RenditionMgt 1 034080xxxxxxxx31c dm_StateOfDocbase 0 035080xxxxxxxx32b dm_SwapInfo 1 036080xxxxxxxx32c dm_UpdateStats 0 037080xxxxxxxx333 dm_UserChgHomeDb 1 038080xxxxxxxx331 dm_UserRename 1 039080xxxxxxxx320 dm_VersionMgt 1 040080xxxxxxxx3bb dm_WfmsTimer 1 041080xxxxxxxx38c replicate_folder 1 042....43080xxxxxxxed67 HUO_MyCustomJob1 1 044080xxxxxxx103b HUO_MyCustomJob2 0 045080xxxxxxx1f9d HUO_MyCustomJob3 0 046080xxxxxxxxf6b HUO_MyCustomJob4 0 0
That’s all!!
Huseyin