Get the stage name in all jobs

[Umberto]

Hi

I need to look for a Job referencing a stage, Teradata export Stage, with a particular name. I think to do that using dsjob utility in a Windows Shell Script. It list all jobs existing in my project and for each of them it list all stages. I qualified the stage interesting me filtered them by the names.

Is there another way to have the same information????

Thank you very much in advance....

Umberto

[ArndW]

That is a good method, particularly if you have it working. You could export the project into a .dsx file and search that file in a text editor. Or write some code around DSGetProjectInfo(), DSGetJobInfo(), DSGetStageInfo() either in DS/Basic or in C++

[lstsaur]

Another way to get the information that you want is to use RTI's Job Control Web Service which exposes the DataStage Job Control API, e.g., GetProjectNames, GetJobNames, GetJobParameters, GetStageName, GetLinkNames, RunJob, etc.

[kduke]

Code: Select all

Select
   NAME as StageName
From
   DS_JOBOBJECTS
Where
   OLETYPE LILE '%Stage'
;

Should get you close.

[ray.wurlod]

Suspect job name is also required, so a join to DS_JOBS is needed.

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 '%Stage%' 
ORDER BY 1, 2 ;