Job Type code list for ujo_job table

Products

• Autosys Workload Automation

Issue/Introduction

Looking to obtain a list for translation of the ujo_job.job_type codes.

Example: 98 = BOX, 99 = CMD

Environment

Release : 12.x

Component : CA Workload Automation AE (AutoSys)

Resolution

Here is a query and the results against an AutoSys 12.x db table, ujo_meta_enumeration.

select enumeration||','||str_value from ujo_meta_enumerations
where enum_name='jobtype';

99,CMD
99,C
98,BOX
98,B
119,W
119,WCCWEB
203,SQL
204,DBPROC
205,DBMON
206,DBTRIG
102,FW
102,F
209,FTP
210,MICROFOCUS
211,OMEL
212,OMTF
213,OMP
214,OMS
215,OMCPU
216,OMIP
217,OMD
218,OASG
219,OASET
220,I5
221,PS
222,SAP
223,SAPBWIP
224,SAPBWPC
225,SAPBDC
226,SAPDA
227,SAPPM
228,SAPEVT
229,SAPJC
230,ZOS
231,ZOSM
232,ZOSDST
233,WBSVC
234,JMSPUB
235,SESSBEAN
236,HTTP
237,POJO
238,JAVARMI
239,JMSSUB
240,JMXMAG
241,JMXMAS
242,JMXMOP
243,JMXSUB
244,ENTYBEAN
245,JMXMREM
248,JMXMC
249,SNMPGET
250,SNMPSET
251,WOL
252,OACOPY
253,SCP
255,FT
256,PROXY
257,PAPROC
258,PAREQ
259,WSDOC
260,HDFS
261,OOZIE
262,HIVE
263,SQOOP
264,PIG
265,INFORMATICA
266,SQLAGENT
267,SPARK
301,DBARG
302,WSPARM
303,WSCRIT
304,SAPREC
305,SAPPRT
306,SAPID
307,SAPSTEP
308,SAPARC
309,STRINGS
311,ZDC
313,WSSEC
320,WSOUTPUT