Hi All,
I want my batch file to check for year-end(31-Dec-2016)condition and run the SQL file every year end and provide the reports.
For example :-
I have a batch file which run daily and executing few SQL files mentioned in it.
I want the some of the SQLfile in the batch script check for the date condition and execute the SQ file on that particular day (Every Year end like 31-Dec )
The below sample command runs on every Monday
if %date:~0,3%==Mon @sqlplus abc/abc@DEVDB@E:\weekly\scripts\report.sql
I am not good in windows command, Please help me with explanation.
Thanks in Advance!
Ramya