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.
dssearch command has bug
Moderators: chulett, rschirm, roy
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.
"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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: