Someone had asked this question ... maybe this will help .. Batch mode report generation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To run a report without being prompted, assign values to the and the report name before running spreport.
The variables are: begin_snap -> specifies the begin Snapshot Id end_snap -> specifies the end Snapshot Id report_name -> specifies the Report output name e.g. on Unix: SQL> connect perfstat/perfstat SQL> define begin_snap=1 SQL> define end_snap=2 SQL> define report_name=batch_run SQL> @?/rdbms/admin/spreport spreport will no longer prompt for the above information. Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2