Craig,
I am still not able to get the results. My requirement is also to find out the number of jobs (Server and Parallel) using odbc stage.
I tried this query for getting the number of jobs (server) using odbc stages and It works fine.
Code: Select all
SELECT BREAK ON "'O'" DS_JOBS.NAME JobName, DS_JOBOBJECTS.NAME StageName FMT '48L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND DS_JOBOBJECTS.OLETYPE LIKE '%CODBCStage%' AND DS_JOBS.JOBTYPEIND LIKE '0' ORDER BY 1, 2 ;
When I am trying to find out the number of jobs using PxOdbc stage in Parallel Jobs, I do not get any results.
Code: Select all
SELECT BREAK ON "'O'" DS_JOBS.NAME JobName, DS_JOBOBJECTS.NAME StageName FMT '48L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND DS_JOBOBJECTS.OLETYPE LIKE '%PxOdbc%' AND DS_JOBS.JOBTYPEIND LIKE '3' ORDER BY 1, 2 ;
Here is an output from the command
Code: Select all
SELECT DISTINCT OLETYPE FROM DS_JOBOBJECTS;
Code: Select all
OLEType.............
CSeqInput
CCustomStage
CCustomOutput
CJSActivityInput
CJSJobActivity
CTrxOutput
CStdPin
CAnnotation
CJSActivityOutput
CCustomInput
CTrxInput
CTransformerStage
CJSSequencer
CStdOutput
CHashedOutput
CHashedFileStage
CJSMailActivity
CHashedInput
CContainerView
CODBCOutput
CJSExecCmdActivity
Press any key to continue...
$<50>OLEType.............
CJSTerminatorActivit
y
CJobDefn
CSeqOutput
CODBCStage
CJSCondition
CSeqFileStage
CJSEndLoopActivity
CJSRoutineActivity
CJSUserVarsActivity
CJSStartLoopActivity
CContainerStage
CContainerDefn
CRecord
34 records listed.