Check TPA ARC (Backup / Restore) status from DD/D !!

If we don't have Netvault installed, but have access to the teradata dictionary the below script helps us to find the status of the Backup or Restore of the TPA.

/* Script to report ARC status */

SELECT * FROM DBC.RCEVENT WHERE OPERATIONINPROCESS = 'Y' ;

This may report all failed events aswell, to filter it down to 2 days an additional where clause could be used.

SELECT *
FROM DBC.RCEVENT
WHERE OPERATIONINPROCESS = 'Y'
AND CREATEDATE > DATE -1
;