SQL Queries - CAST Knowledge Base - Queries on jobs - How to get the job type name and its description

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

This page give you the information of jobs on your knowledge base: the id, the name and description of the job.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(error)
Microsoft SQL Server(error)
CSS(tick)
Query for CSS
SELECT t.*
FROM   typ t,
       typcat tc,
       cat c
WHERE  t.idtyp = tc.idtyp
       AND tc.idcatparent = c.idcat
       AND c.idcat = 5500
ORDER  BY idtyp
Query result example
 

707;"JOB_PLSQL_ANALYZER";"PL/SQL Analyzer";"ACTIVE "
708;"JOB_FORMS_ANALYZER";"Oracle Forms Analyzer";"ACTIVE "
709;"JOB_FLATFILES_ANALYZER";"PL/SQL script Analyzer";"ACTIVE "
710;"JOB_TSQL_ANALYZER";"T-SQL Analyzer";"ACTIVE "
711;"JOB_VB_ANALYZER";"Visual Basic Analyzer";"ACTIVE "
712;"JOB_PB_ANALYZER";"PowerBuilder Analyzer";"ACTIVE "
713;"JOB_DELPHI_ANALYZER";"Delphi Analyzer";"ACTIVE "
714;"JOB_C_ANALYZER";"C++ Analyzer";"ACTIVE "
717;"JOB_JAVA_ANALYZER";"Java Analyzer";"ACTIVE "
718;"CAST_Web_Asp_JobAnalyzer";"ASP Analyzer";"ACTIVE "
719;"JOB_JSP_ANALYZER";"J2EE Analyzer";"ACTIVE "
720;"CAST_DotNet_Job_Analyzer";".NET Analyzer";"DEPRECATED"
721;"JOB_BO_ANALYZER";"BusinessObjects Analyzer";"ACTIVE "
722;"JOB_EJB_ASSISTANT";"EJB Assistant";"ACTIVE "
724;"JOB_IMPORT_COM_COMPONENT";"Import COM Component";"ACTIVE "
725;"JOB_WORD_ASSISTANT";"Word Assistant";"ACTIVE "
727;"JOB_METRICS_ASSISTANT";"Metrics Assistant";"ACTIVE "
728;"JOB_GENERIC_SCANNER";"Generic Code Scan";"ACTIVE "
729;"JOB_RF_PLSQL";"PL/SQL Reference Finder";"ACTIVE "
730;"JOB_RF_FORMS";"Oracle Forms Reference Finder";"ACTIVE "
731;"JOB_RF_TSQL";"T-SQL Reference Finder";"ACTIVE "
732;"JOB_RF_VB";"VB Reference Finder";"ACTIVE "
733;"JOB_RF_PB";"PB Reference Finder";"ACTIVE "
734;"JOB_RF_DELPHI";"Delphi Reference Finder";"ACTIVE "
735;"JOB_RF_C";"C++ Reference Finder";"ACTIVE "
736;"JOB_RF_DOTNET";".NET Reference Finder";"DEPRECATED"
739;"JOB_RF_JAVA";"Java Reference Finder";"ACTIVE "
740;"CAST_Web_ASP_JobRF";"ASP Reference Finder";"ACTIVE "
741;"JOB_RF_JSP";"J2EE Reference Finder";"ACTIVE "
742;"JOB_RF_E_ANALYZER";"EAnalyzer Reference Finder";"ACTIVE "
743;"JOB_RF_GENERIC_CODE_SCANNER";"GCS Reference Finder";"ACTIVE "
756;"JOB_CHILD_RF_PLSQL";"PL/SQL Reference Finder";"ACTIVE "
757;"JOB_CHILD_RF_FORMS";"Oracle Forms Reference Finder";"ACTIVE "
758;"JOB_CHILD_RF_TSQL";"T-SQL Reference Finder";"ACTIVE "
759;"JOB_CHILD_RF_VB";"VB Reference Finder";"ACTIVE "
760;"JOB_CHILD_RF_PB";"PB Reference Finder";"ACTIVE "
761;"JOB_CHILD_RF_DELPHI";"Delphi Reference Finder";"ACTIVE "
762;"JOB_CHILD_RF_C";"C++ Reference Finder";"ACTIVE "
763;"JOB_CHILD_RF_DOTNET";".NET Reference Finder";"DEPRECATED"
766;"JOB_CHILD_RF_JAVA";"Java Reference Finder";"ACTIVE "
767;"JOB_CHILD_RF_ASP";"ASP Reference Finder";"ACTIVE "
768;"JOB_CHILD_RF_JSP";"J2EE Reference Finder";"ACTIVE "
769;"JOB_CHILD_RF_E_ANALYZER";"EAnalyzer Reference Finder";"ACTIVE "
770;"JOB_CHILD_RF_GENERIC_CODE_SCANNER";"GCS Reference Finder";"ACTIVE "
771;"JOB_JDO_ASSISTANT";"JDO Assistant";"ACTIVE "
775;"JOB_SQL_TOOL";"SQL Tool";"ACTIVE "
776;"JOB_EXTERN_TOOL";"External Tool";"ACTIVE "
777;"JOB_CSV_TOOL";"Update CAST System Views";"ACTIVE "
778;"CAST_Web_JobEAnalyser";"EAnalyzer";"ACTIVE "
784;"JOB_TABULARLINKSCANNER";"Tabular Link Scanner";"ACTIVE "
787;"JOB_DB2_ANALYZER";"DB2 Analyzer";"ACTIVE "
788;"JOB_RF_DB2";"DB2 Reference Finder";"ACTIVE "
789;"JOB_CHILD_RF_DB2";"DB2 Reference Finder";"ACTIVE "
795;"JOB_RF_PLSQLSCRIPT";"PL/SQL Script Reference Finder";"ACTIVE "
796;"JOB_CHILD_RF_PLSQLSCRIPT";"PL/SQL Script Reference Finder";"ACTIVE "
812;"JOB_FORMS_CARTOGRAPHY";"Oracle Forms Cartography";"ACTIVE "
813;"JOB_FORMS_SCHEMA_FEEDING";"Oracle Forms Schema Feeding";"ACTIVE "
825;"JOB_LIBRARY_TOOL";"Update Library Links";"ACTIVE "
826;"JOB_MAINFRAME_ANALYZER";"Mainframe Analyzers";"ACTIVE "
827;"JOB_RF_MAINFRAME";"Mainframe Reference Finders";"ACTIVE "
828;"JOB_CHILD_RF_MAINFRAME";"Mainframe Reference Finders";"ACTIVE "
838;"JOB_WEBSERVICES_ASSISTANT";"Web Services Assistant";"ACTIVE "
893;"JOB_ABAP_ANALYZER";"Abap Analyzer";"ACTIVE "
894;"JOB_RF_ABAP";"Abap Reference Finder";"ACTIVE "
895;"JOB_CHILD_RF_ABAP";"Abap Reference Finder";"ACTIVE "
897;"JOB_AUTOVIEW_TOOL";"Enlighten Views Generation";"ACTIVE "
898;"JOB_STDOC_TOOL";"Standard Documentation Generation";"ACTIVE "
899;"JOB_COST_TOOL";"Cost Estimation Assistant";"ACTIVE "
3000;"JOB_KB_API_TOOL";"Update CAST Knowledge Base";"ACTIVE "
3001;"JOB_FINALIZATION";"Snapshot Preparation Assistant";"ACTIVE "
134090;"JOB_SSRS_ANALYZER";"SSRS Analyzer";"ACTIVE "
134091;"JOB_RF_SSRS";"SSRS Reference Finder";"ACTIVE "
134092;"JOB_CHILD_RF_SSRS";"SSRS Reference Finder";"ACTIVE "
135090;"JOB_SSIS_ANALYZER";"SSIS Analyzer";"ACTIVE "
135091;"JOB_RF_SSIS";"SSIS Reference Finder";"ACTIVE "
135092;"JOB_CHILD_RF_SSIS";"SSIS Reference Finder";"ACTIVE "
137651;"CAST_DotNet_Job_NewAnalyzer";".NET Analyzer (New)";"ACTIVE "
137652;"CAST_DotNet_Job_NewReferenceFinder";".NET Reference Finder (New)";"ACTIVE "
137653;"CAST_DotNet_Job_NewChildReferenceFinder";".NET Reference Finder (New)";"ACTIVE "
137997;"JOB_SQL_ANALYZER";"SQL Analyzers";"ACTIVE "
137998;"JOB_RF_SQL";"SQL Reference Finder";"ACTIVE "
137999;"JOB_CHILD_RF_SQL";"SQL Reference Finder";"ACTIVE "
141181;"JOB_C_CmdLineANALYZER";"C++ Analyzer";"ACTIVE "
141242;"CAST_Forms_Window";"Oracle Forms Window";"ACTIVE "
141257;"JOB_UNIVERSAL_IMPORTER_FILE";"Universal Importer";"ACTIVE "
141258;"JOB_UNIVERSAL_IMPORTER_DB";"Universal Importer";"ACTIVE "
141259;"JOB_UNIVERSAL_IMPORTER_COMBINED";"Universal Importer";"ACTIVE "
141325;"JOB_RP_GENERIC";"Reference Pattern";"ACTIVE "
141382;"JOB_REFERENCE_FINDER_ANALYZER";"Reference Finder Analyzers";"ACTIVE "
141457;"CAST_Forms_Window_Tab";"Oracle Forms Window Tab";"ACTIVE "
141850;"JOB_POWERBUILDER_ANALYZER";"PowerBuilder Analyzers";"ACTIVE "
141884;"CAST_Plugin_Job";"Job for plugins";"ACTIVE "
141930;"CAST_DotNet_CommandLineJob";"Job description suitable for use by command line tool analyzer.exe";"ACTIVE "
1000000;"JOB_UNIVERSAL_ANALYZER";"Universal Analyzer";"ACTIVE "
1000004;"JOB_RF_UNIVERSAL";"Universal Reference Finder";"ACTIVE "
1000005;"JOB_CHILD_RF_UNIVERSAL";"Universal Reference Finder";"ACTIVE "
1000006;"JOB_UNIVERSAL_IMPORTER";"Universal Importer";"ACTIVE "

Query result interpretation
 For each job, the query return the id, the name and description of the job.
Query for Oracle
Enter the SQL query
Query result example

Query result interpretation

Query for SQL server
Enter the SQL query
Query result example

Query result interpretation

Notes/comments



Related Pages