Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 May 2015 @ 22:26:23 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Deletion of Duplicates
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, May 12, 2015 04:50 -->

Hello Forum,

One of our batch jobs got run twice at the same time and have to delete one of the rows.

Its an hourly job.

The actual run and extra run almost run at the same hour and same minute, but the difference is only in seconds and centi seconds.

     Date        Username?  Jobname   starttime                 Endtime                   Status
     12-05-2015  USER1      jOB1      12-05-2015  09:30:01.91   12-05-2015  09:30:41.21   0
     12-05-2015  USER1      jOB1      12-05-2015  09:30:45.83   12-05-2015  09:30:55.03   0

     12-05-2015  USER1      jOB1      12-05-2015  10:30:07.01   12-05-2015  10:30:27.41   0
     12-05-2015  USER1      jOB1      12-05-2015  10:30:28.32   12-05-2015  10:30:58.82   0

Can you suggest How to delete one of these rows here?


Thanks in advance!



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016