dssearch command has bug

ramabbm · Post by **ramabbm** » Thu Oct 12, 2006 11:53 am

When I was playing with dssearch command to search for Jobs used in a Specified Job Sequence, found there is a bug with this command. It is not listing all jobs under subsequences, when you are running subsequences parallel.

Here is my out put.

Stage\Sequence\LOSNew_seq, sequence job
Shared\shr_job00_get_procid, server job
Stage\LOS_CC_ORG_BRM_STG, server job
Stage\LOS_Pricing_BRM, server job
Stage\LOS_loandata_brm_stage, server job
Stage\Sequence\FQ_seq, sequence job
Shared\shr_job00_get_procid, server job
Stage\FQ_FastQualLoanStatistics_BRM, server job
BRM\sequence\BDS_MDM_seq_10, sequence job
Shared\shr_job00_get_procid, server job
BRM\BDS_License_BRM, server job
Address\Address_Job10_LoadHash, server job
BRM_to_MDM\MDMStgAddress_Job10_LoadData, server job
BRM_to_MDM\MDMStgBrmCntcAddress_Job10_LoadData, server job
Stage\BDS_STG_Lookup_License_Type_BRM, server job
Address\Address_Job10_LoadHash, server job
Stage\Key_Mgt_Update, server job
Lookup\seq\BDS_Lookup_Sequence_With_Parameters, sequence job
Lookup\BDS_Lookup_License_Type_BRM, server job
Address\Address_Job10_LoadHash, server job
Lookup\BDS_lookup_address_type_BRM_Stage, server job
Stage\Sequence\BDS_Master_01, sequence job
Stage\Sequence\BDS_Master_02, sequence job
Stage\Sequence\BDS_Master_03, sequence job
Stage\BDS_Stage_HSH, server job

Where as BDS_Master_01, 02, 03 subsequences are running parallel; it is not listing jobs under these sequences.

If there is any alternative way to list jobs under these sequences, please let me know.

kduke · Post by **kduke** » Thu Oct 12, 2006 12:31 pm

Look at viewtopic.php?t=99605

ramabbm · Post by **ramabbm** » Thu Oct 12, 2006 3:02 pm

Thanks for your replay. I have looked your link and got the following query.

"select
DS_JOBS.NAME JobName FMT '40L',
DS_JOBOBJECTS.NAME LinkName FMT '30L',
EVAL DS_JOBOBJECTS."@RECORD<12>" AS JobActivtyJobName FMT '40L'
from
DS_JOBOBJECTS,
DS_JOBS
where
DS_JOBOBJECTS.OLETYPE = 'CJSJobActivity'
and DS_JOBS.NAME = 'Control_Sequence'
and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO"

I have executed above query and it is listing sequences and jobs in the master sequence. But it is not listing nested sequences jobs.

For example: Master sequence has multiple sub-sequences and sub-sequences another set of sub sequences and those sub sequences are calling actual job. The above query is listing first set of jobs and sequences. But it is not listing all child sequences and sub child sequences jobs.

Master Sequences --> SubSequence1 --> Subsequence2-->jobs.

Above query is listing Subseqeunce1 only. However it is not displaying subseqeunce2 and jobs under subseqeunce2.

If would be great if you solution to display all jobs under Master Sequence.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 12, 2006 3:12 pm

You have all the table and column names your require in that query. Why don't YOU have a go at designing a recursive query?

kduke · Post by **kduke** » Thu Oct 12, 2006 3:24 pm

Amen brother.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 12, 2006 4:49 pm

And, when you do solve it, please post the solution.