How to get sequence name from DS_JOBS?

rajendharreddy · Post by **rajendharreddy** » Mon Jan 21, 2008 12:39 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 21, 2008 1:43 am

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)?

rajendharreddy · Post by **rajendharreddy** » Mon Jan 21, 2008 1:59 am

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.

chulett · Post by **chulett** » Mon Jan 21, 2008 8:09 am

Code: Select all

LIST DICT DS_JOBS

And please try searching the forums, this has been a very popular topic lately and people get tired of explaining the same thing over and over. And over.