• State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 95 subscribers
  • Views 2897 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

what is the name of the table holds the job status?

hemasaiy534
over 6 years ago

Hello,

What is the name of the table where user can check whether the job ended with success , error , end with error/success....table and column name?

Parents
  • 0 over 6 years ago

    Hello,

    If the job freezes ..... JOBQUEUE .... Ready2EXE .... value 'FROZEN'

    If the job has been moved to history .... JOBHISTORY ..... WasError ...... True of False

    HTH, Barry.

  • 0 over 6 years ago in reply to Barry Jackson

    So if the job get frozen then it will be in JobQeue table Ready2EXE column and value will be 'Frozen'

    If the is normally processed (success) - what it will be the value in JobHistory table wasError column?

    If the the user end's with success or error - what it will be the value in JobHistory table wasError column?

  • 0 over 6 years ago in reply to hemasaiy534

    So if the job get frozen then it will be in JobQeue table Ready2EXE column and value will be 'Frozen'

    >> Yes .... IF ..... the job step has 'Stop on error' set .... otherwise it will go to JobHistory with WasError = True

    If the is normally processed (success) - what it will be the value in JobHistory table wasError column?

    >> False

    If the the user end's with success or error - what it will be the value in JobHistory table wasError column?

    >> If the job step itself had an error .... WasError will be True.

    >> End with Success/Error only determines of the jobchain should continue with the next step(s) or end at that point.

Reply
  • 0 over 6 years ago in reply to hemasaiy534

    So if the job get frozen then it will be in JobQeue table Ready2EXE column and value will be 'Frozen'

    >> Yes .... IF ..... the job step has 'Stop on error' set .... otherwise it will go to JobHistory with WasError = True

    If the is normally processed (success) - what it will be the value in JobHistory table wasError column?

    >> False

    If the the user end's with success or error - what it will be the value in JobHistory table wasError column?

    >> If the job step itself had an error .... WasError will be True.

    >> End with Success/Error only determines of the jobchain should continue with the next step(s) or end at that point.

Children
No Data