SQL Queries - CAST Knowledge Base - Queries on jobs - How to retrive external tool job names

Purpose of Query

This query retrive external tool job names.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS✅

Query for CSS

SELECT infval 
FROM   anadsc 
WHERE  inftyp = 25010 
       AND infsubtyp = 1

Query result example

We don’t have an example

Query result interpretation

The query return the name of External Tools

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