Dear Expert,
Below code is for to take the backup of database by daily time stamp. I need vital help to make my script automatic sending me email if it sucess or fail.
Code:
echo on
@REM Seamonkey�s quick date batch (MMDDYYYY format)
@REM Setups %date variable
@REM First parses month, day, and year into mm , dd, yyyy formats and then combines to be MMDDYYYY
FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B
FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B
SET date=%dd%%mm%%yyyy%
exp USER/password@alias file='D:\Backup\%date%.dmp' log='D:\Backup\%date%.log full=N
I want to put if conditions to check the logfile follwing things are
Code: ("error failed ora- warnings terminated" )
if exist send email failed else success.
Thanks in advance.
Thanks You,
---------- Post updated 06-27-12 at 05:44 AM ---------- Previous update was 06-26-12 at 08:26 AM ----------
If any alternative method is also Appreciated.