Job validates but not runs
Moderators: chulett, rschirm, roy
Job validates but not runs
Hi,
i have sets of jobs being called through a sequence, in these sequence out of 10 jobs only 2 jobs are running fine and other jobs are just validating even if the execution action is Reset if Required, Then Run.
Pls help me out in order to resolve this issue.
Thanks in advance,
Senthil
i have sets of jobs being called through a sequence, in these sequence out of 10 jobs only 2 jobs are running fine and other jobs are just validating even if the execution action is Reset if Required, Then Run.
Pls help me out in order to resolve this issue.
Thanks in advance,
Senthil
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Even if you set the Job activities to "Validate" as the run mode the sequence will compile. Please answer Arnd's actual question.senthilmp wrote:Yes, am sure that i re compiled the sequence..
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
CTCTypeSeq..JobControl (@Coordinator): Summary of sequence run
04:25:34: Sequence started (checkpointing on)
04:25:34: Start_date (JOB EdwSQLStatement.EdwSqlStatements_EcomPricing_getLastRunDate) started
04:25:34: Start_date (JOB EdwSQLStatement.EdwSqlStatements_EcomPricing_getLastRunDate) finished, status=11 [Validated OK]
04:25:34: Type1 (JOB Type1FixedPriceCTCJob) started
04:25:34: Type1 (JOB Type1FixedPriceCTCJob) finished, status=11 [Validated OK]
04:25:35: Type2Type3 (JOB Type2andType3Seq) started
04:25:57: Type2Type3 (JOB Type2andType3Seq) finished, status=1 [Finished OK]
04:25:57: Type2Current (JOB Type2CurrentCountryPricelistsJob) started
04:25:57: Type2Current (JOB Type2CurrentCountryPricelistsJob) finished, status=11 [Validated OK]
04:25:58: Type3Current (JOB Type3CurrentGlobalPricelistsJob) started
04:25:58: Type3Current (JOB Type3CurrentGlobalPricelistsJob) finished, status=11 [Validated OK]
04:25:58: Type4 (JOB Type4CTCDiscountsStandardJob) started
04:25:58: Type4 (JOB Type4CTCDiscountsStandardJob) finished, status=11 [Validated OK]
04:25:59: Type4Campaign (JOB Type4CTCDiscountsCampaignJob) started
04:25:59: Type4Campaign (JOB Type4CTCDiscountsCampaignJob) finished, status=11 [Validated OK]
04:26:00: Type5 (JOB Type5OrderGroupDiscountsCampaignJob) started
04:26:00: Type5 (JOB Type5OrderGroupDiscountsCampaignJob) finished, status=11 [Validated OK]
04:26:00: Campaign_ChangeJob (JOB Z_Campaign_ChangeJob) started
04:26:01: Campaign_ChangeJob (JOB Z_Campaign_ChangeJob) finished, status=11 [Validated OK]
04:26:02: Campaign_NewJob (JOB Z_Campaign_NewJob) started
04:26:02: Campaign_NewJob (JOB Z_Campaign_NewJob) finished, status=11 [Validated OK]
04:26:02: EcomPricingLastRuntimeJob (JOB EcomPricingLastRuntimeJob) started
04:26:03: EcomPricingLastRuntimeJob (JOB EcomPricingLastRuntimeJob) finished, status=11 [Validated OK]
04:26:03: edw_batch_update_ods (JOB EdwUpdateBatchDatesODSJob.edw_batch_update_EcomPricing) started
04:26:03: edw_batch_update_ods (JOB EdwUpdateBatchDatesODSJob.edw_batch_update_EcomPricing) finished, status=11 [Validated OK]
04:26:03: Split_Files (COMMAND /data/datastage/Data/EMEA/TargetFiles/ECOMMERCE/PRICING/SplitFiles.sh) started
04:26:04: Split_Files finished, reply=0
04:26:04: Convert_Tmp_to_Txt (COMMAND /data/datastage/Data/EMEA/TargetFiles/ECOMMERCE/PRICING/Convert_txt.sh) started
04:26:04: Convert_Tmp_to_Txt finished, reply=0
04:26:04: Sequence finished OK
04:25:34: Sequence started (checkpointing on)
04:25:34: Start_date (JOB EdwSQLStatement.EdwSqlStatements_EcomPricing_getLastRunDate) started
04:25:34: Start_date (JOB EdwSQLStatement.EdwSqlStatements_EcomPricing_getLastRunDate) finished, status=11 [Validated OK]
04:25:34: Type1 (JOB Type1FixedPriceCTCJob) started
04:25:34: Type1 (JOB Type1FixedPriceCTCJob) finished, status=11 [Validated OK]
04:25:35: Type2Type3 (JOB Type2andType3Seq) started
04:25:57: Type2Type3 (JOB Type2andType3Seq) finished, status=1 [Finished OK]
04:25:57: Type2Current (JOB Type2CurrentCountryPricelistsJob) started
04:25:57: Type2Current (JOB Type2CurrentCountryPricelistsJob) finished, status=11 [Validated OK]
04:25:58: Type3Current (JOB Type3CurrentGlobalPricelistsJob) started
04:25:58: Type3Current (JOB Type3CurrentGlobalPricelistsJob) finished, status=11 [Validated OK]
04:25:58: Type4 (JOB Type4CTCDiscountsStandardJob) started
04:25:58: Type4 (JOB Type4CTCDiscountsStandardJob) finished, status=11 [Validated OK]
04:25:59: Type4Campaign (JOB Type4CTCDiscountsCampaignJob) started
04:25:59: Type4Campaign (JOB Type4CTCDiscountsCampaignJob) finished, status=11 [Validated OK]
04:26:00: Type5 (JOB Type5OrderGroupDiscountsCampaignJob) started
04:26:00: Type5 (JOB Type5OrderGroupDiscountsCampaignJob) finished, status=11 [Validated OK]
04:26:00: Campaign_ChangeJob (JOB Z_Campaign_ChangeJob) started
04:26:01: Campaign_ChangeJob (JOB Z_Campaign_ChangeJob) finished, status=11 [Validated OK]
04:26:02: Campaign_NewJob (JOB Z_Campaign_NewJob) started
04:26:02: Campaign_NewJob (JOB Z_Campaign_NewJob) finished, status=11 [Validated OK]
04:26:02: EcomPricingLastRuntimeJob (JOB EcomPricingLastRuntimeJob) started
04:26:03: EcomPricingLastRuntimeJob (JOB EcomPricingLastRuntimeJob) finished, status=11 [Validated OK]
04:26:03: edw_batch_update_ods (JOB EdwUpdateBatchDatesODSJob.edw_batch_update_EcomPricing) started
04:26:03: edw_batch_update_ods (JOB EdwUpdateBatchDatesODSJob.edw_batch_update_EcomPricing) finished, status=11 [Validated OK]
04:26:03: Split_Files (COMMAND /data/datastage/Data/EMEA/TargetFiles/ECOMMERCE/PRICING/SplitFiles.sh) started
04:26:04: Split_Files finished, reply=0
04:26:04: Convert_Tmp_to_Txt (COMMAND /data/datastage/Data/EMEA/TargetFiles/ECOMMERCE/PRICING/Convert_txt.sh) started
04:26:04: Convert_Tmp_to_Txt finished, reply=0
04:26:04: Sequence finished OK
Yes, first some jobs in the sequence was set to Validate and then i change those to Reset if Require, Then Run, Compile Each and every Job and also the Sequence.
After compiling and Running also the jobs are validating. I was able to resolve the issue as stated by one of the Replies from ArndW
'try "save as" of your job sequence under a completely different name, compiling and running it '
But am trying to know why it was not happening to the original sequence itself.
After compiling and Running also the jobs are validating. I was able to resolve the issue as stated by one of the Replies from ArndW
'try "save as" of your job sequence under a completely different name, compiling and running it '
But am trying to know why it was not happening to the original sequence itself.