AutoSys 11.3.6 job_type code translation

[AkBar Dar]

I am looking for Job codes cross reference information. It was used to command, box, and file watcher, and there are close 50 job types. I am looking at the database and producing some queries results, where I am getting a job type codes, I cannot find any code translations. Please advise.

AkBar Dar

------------------------------
AkBar Dar
IT Administrator
AVANGRID
CT USA
------------------------------

[Linda Williams]

As it happens, I recently needed to look at this so I'll tell you what I know. 

213=OMP
102=FW
255=FT
212=OMTF
99=CMD
203=SQL
98=BOX


There are more, but that's all we use in our environment. 

from sqlplus you can do 

select distinct job_type from ujo_job;

then just select job_name from ujo_job where job_type=<number> for each job_type you have. 

do an autorep on the job name and you'll have the type.

[Steve Carrobis]

you can join ujo_types .UJO_META_ENUMERATIONS look for job_type for enum name.
next one costs ;-)

[AkBar Dar]

Thanks Guru

------------------------------
AkBar Dar
IT Administrator
AVANGRID
CT USA
------------------------------

[Steve Carrobis]

 

You are most welcome.

 

 

Steve C.

 

Nothing in this message is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.

Confidentiality Note: This message is intended only for the person or entity to which it is addressed. It may contain confidential and/or privileged material. Any review, transmission, dissemination or other use, or taking of any action in reliance upon this message by persons or entities other than the intended recipient is prohibited and may be unlawful. If you received this message in error, please contact the sender and delete it from your computer.