Hi,
I have following two requirements.
1) How to get only sequence name list from the project?
2) How to get the individual job name list which belongs to
particular sequence.
Actually, I have used "SELECT NAME FROM DS_JOBS", but it retrieves all the jobs plus sequences. But here I need to get only sequence names in first stage. Then jobs which belong to a sequence in second stage.
Can any one help me on this?
Thanks.
How to get sequence name from DS_JOBS?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DS_JOBS has a job type indicator that can be used to filter by job type. This has been shown before; a Search will find it.
There is a recent (currently active?) thread on getting the job list from a sequence. Are you interested in design time (all the job activities in the job sequence) or run time (just the jobs that were called from the sequence because of the execution logic)?
There is a recent (currently active?) thread on getting the job list from a sequence. Are you interested in design time (all the job activities in the job sequence) or run time (just the jobs that were called from the sequence because of the execution logic)?
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.
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
Hi Ray,
I fired "SELECT * FROM DS_JOBS", it retrieved only 4 columns (i.e. Job name, Description, No. and Category). I have not found Job type.
I tried with below query, but it has trown error.
SELECT NAME FROM DS_JOBS WHERE JOB_TYPE='Sequence'
Error: Unexpected symbol "JOB_TYPE"
Could you please tell me the exact query?
Thanks.
I fired "SELECT * FROM DS_JOBS", it retrieved only 4 columns (i.e. Job name, Description, No. and Category). I have not found Job type.
I tried with below query, but it has trown error.
SELECT NAME FROM DS_JOBS WHERE JOB_TYPE='Sequence'
Error: Unexpected symbol "JOB_TYPE"
Could you please tell me the exact query?
Thanks.
Code: Select all
LIST DICT DS_JOBS
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers