Archives of the TeradataForum

Message Posted: Fri, 09 Jan 2004 @ 17:21:07 GMT

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

Phil,

You could use the DBC.Events view - use CreateDate, EventNum and EventType(DUMP).

If an ARCHIVE script specifies more than one database, ARCMAIN archives the databases and all their tables and stored procedures in alphabetical order.

If an ARCHIVE script specifies multiple tables, ARCMAIN archives the tables in alphabetical order of table within the database.

This would give you a starting list of objects for an event--but as you indicated, you'd still have to cross-reference it to your Netvault job info....(yek!)

Thanks,

Lisa

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