Need to find where "Failure exit codes" are located in the DB.
SQL server 2008 R2 is the db we use.
Failcodes also being stored in table ujo_sched_info in column fail_codes, but I guess you figured that out already.
What product are you using for your manager?
I think event manegment defiend the db at install, though not 100% sure.
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?
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)
It might be the table ujo_intcodes in AEDB your looking for.
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'
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.
Thank you for your help
Retrieving data ...