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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS(tick)
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