Duplicate Process Identification

Question

Hi Team, 
 I have a process which is executing twice every time on same object ,how can i include a generating condition if any process is in progress do not generate again?

Barry Jackson · Accepted Answer

Hi, 
 
Yes you can examine the basisobjectkey of the running process that should contain the uid of the person the job is being executed for. Then you would check if the current uid matches that uid or not. 
 
HTH, B.

Barry Jackson · Answer

Hi, 
 
Set this as the gen con for your process: 
 
Dim f As ISqlFormatter = Connection.SqlFormatter 
 
Value = Not Connection.Exists("JobQueue", f.Comparison("jobchainname", myChain.Name, ValType.String, CompareOperator.Equal)) 
 
If there's a job in the queue with the same name, another won't generate. 
 
But you also might want to investigate why you are getting 2 executions. 
 
HTH, Barry.