Image not found Collapse All | Expand All | Show Default


FixEtlElapsedTime
DataStage Job Report
Generated 2005-02-15 08:26:49pm

 - Job Design  

Image not found

 - Job Information  

 - Job Properties (6) 

Property Value
Object Type Server 
Full Description Job: FixEtlElapsedTime
=================================================================
Description:
This job fixes a bug in dsjob -report used in DSJobReportDb where it
does not calculate ElapsedSecs properly when it crosses midnight.
=================================================================
Parameters:
1. TargetDSN
2. TargetPwd
3. TargetUser
=================================================================
Sources:
Same as targets.
=================================================================
Targets:
1. ETL_JOB_HIST
2. ETL_ROW_HIST
3. ETL_PARAM_HIST
=================================================================
To use in next job:
=================================================================
Modification History
=================================================================
Developer Date Modification description
======== ========= ==============================================
kduke 2005-02-10 created
======== ========= ==============================================















 
Category EtlStats 
Multiple Instance False 
Job Version Number 40.0.0 
Hash File Cache Sharing False 

 - Parameters (3) 

Parameter Name Prompt Default Value Help Text
TargetDSN  TargetDSN  kduke   
TargetUser  TargetUser  etluser   
TargetPwd  TargetPwd  LDH@9:VA=93L0O5I<;J  

 - Stages (6) 



 - Source Stages (2) 

 - ETL_JOB_HIST_In (oraoci8) 

 - Stage Properties (4) 

Property Value
DATABASE #TargetDSN# 
USERID #TargetUser# 
PASSWORD HD:@I:V@L93?0GEI<;J<0K1GB
ISOPS NO 

 - Output Links (1) 

+ JobStats triggers XfmStats  


 - ETL_ROW_HIST_In (oraoci8) 

 - Stage Properties (4) 

Property Value
DATABASE #TargetDSN# 
USERID #TargetUser# 
PASSWORD HD:@I:V@L93?0GEI<;J<0K1GB
ISOPS NO 

 - Output Links (1) 

+ RowStats triggers XfmRows  



 - Processing Stages (2) 

 - XfmStats (transformer) 

+ Stage Variables (0) 

 - Input Links (1) 

+ JobStats triggered by ETL_JOB_HIST_In  

 - Output Links (1) 

+ ETL_JOB_HIST triggers ETL_JOB_HIST  


 - XfmRows (transformer) 

+ Stage Variables (0) 

 - Input Links (1) 

+ RowStats triggered by ETL_ROW_HIST_In  

 - Output Links (1) 

+ ETL_ROW_HIST triggers ETL_ROW_HIST  



 - Target Stages (2) 

 - ETL_JOB_HIST (oraoci8) 

 - Stage Properties (4) 

Property Value
DATABASE #TargetDSN# 
USERID #TargetUser# 
PASSWORD HD:@I:V@L93?0GEI<;J<0K1GB
ISOPS NO 

 - Input Links (1) 

+ ETL_JOB_HIST triggered by XfmStats  


 - ETL_ROW_HIST (oraoci8) 

 - Stage Properties (4) 

Property Value
DATABASE #TargetDSN# 
USERID #TargetUser# 
PASSWORD HD:@I:V@L93?0GEI<;J<0K1GB
ISOPS NO 

 - Input Links (1) 

+ ETL_ROW_HIST triggered by XfmRows  






Ascential and DataStage are trademarks of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions.
For questions or comments regarding this utility, contact tony.curcio@ascentialsoftware.com.