Trying to locate attribute «Failure exit codes» in database

[Anon Anon]

Need to find where "Failure exit codes" are located in the DB.

 

SQL server 2008 R2 is the db we use.

[Stacey Ruggiero]

What product are you using for your manager?

[Anon Anon]

I think event manegment defiend the db at install, though not 100% sure.

[LARS PERSSON]

I am trying to understand your question, have you installed the EM-parts of CCS in WAAE?

Are you trying to populate mdb with eventmangement-rules (message records/actions) and are looking for the codes when the operdaemon fails in processing an event?

[Anon Anon]

We've created a custom sms service that reads the failures from the database when a job fails, and send a text msg to whoevere is resposinble for monotoring the system.

 

When you create a new job, you can there define the exit codes to ignore or include, and these are the correlating values I'm trying to find in the database (SQL server)

[LARS PERSSON]

It might be the table ujo_intcodes in AEDB your looking for.

[Anon Anon]

Thanks for the reply Lars, though it seems that the values in that table is related to diffrent statues, and not the manualy set exit codes, eg. I can set exit codes to: 2-9999, and I'm trying to locate where the value '2-9999' is then stored in the db for 'Failure exit codes'

[LARS PERSSON]

Now finally I follow , it seems as if "success exit codes = 2-9999" is stored in the table ujo_sched_info, where you need known the joid to figure out which job you are looking for.

I often use max_exit_success = 1 instead which is stored in the table ujo_job.

[LARS PERSSON]

Failcodes also being stored in table ujo_sched_info in column fail_codes, but I guess you figured that out already.

[Anon Anon]

Thank you for your help