DSXchange

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.

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

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.

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.