Hi ,
The scenario as follows ,
Would like to have a daily spool file of the database health check using the .sql file.
1) the .sql file has been tested
2) the spool output has been tested
Now I need to schedule using either .bat or using procedure + Scheduler.
I have issues with using SPOOL command in procedure , as I understand it is a sqlplus command.
So I am trying to run it with a .bat file.
The question is how can I run the .bat file without entering the username/password?
@D:\test.sql
Thats all I want in the .bat file to be scheduled to run daily using the scheduler.
Thanks!