Archives of the TeradataForum

Message Posted: Wed, 06 Jun 2007 @ 14:30:13 GMT

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

     sel 'BACKUP still Running. Please Check.' (title ' ')
     where 0 <   (sel count(*) from dbc.sessioninfo
                  where partition like 'HUTPARSE%');

or when you run this:

     sel count(*) from dbc.sessioninfo
                  where partition like 'HUTPARSE%';

you get 0 if no backup is running, and a number > 0 (the number of backup sessions in the system) if backup is running.

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