• State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 7482 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

Duplicate Process Identification

Pradeep Pola
over 7 years ago

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?

Parents
  • 0 over 7 years ago
    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.
Reply
  • 0 over 7 years ago
    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.
Children
No Data