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
Get the stage name in all jobs
Moderators: chulett, rschirm, roy
Code: Select all
Select
NAME as StageName
From
DS_JOBOBJECTS
Where
OLETYPE LILE '%Stage'
;
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 ;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.