Archives of the TeradataForum

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

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

<-- 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>>