hi there
currently we are running a job via unix which is email the xls file everyday
exit 1
fi
if [ -f $LOG_DIR/Unlinked_SALESREP
S.xls ]
then
echo "Mailing Unlinked_SALESREPS_dos.xls
to ${MAIL_LIST} "
sed -e '1,$s/$/^M/' < $LOG_DIR/Unlinked_SALESREP
S.xls > Unlinked_SALESREPS_dos.xls
uuencode Unlinked_SALESREPS_dos.xls
Unlinked_SALESREPS_dos.xls
| \
mailx -s "Unlinked_SALESREPS_dos.xl
s" "${MAIL_LIST}"
fi
now i convert unix scrpit to dos cmd but cant figure how can i send xls file to email please advice
the script is below can u please let me know how to email this file Unlinked_SALESREPS_dos.xls
once the job run successful
set JS=Get_Unlinked_Salesreps
"%dmhome%\rundsjob" -P "ORACLE" %catalog% %JS% -A%dbaliases% -e%environ% -V%tracev% -L%log_file% -VDS_LOG_DIR=%log_dir% -VDS_DATA_DIR=%data_dir%
IF errorlevel 1 GOTO :failed_run
echo.
echo Get Unlinked Salesreps build completed successfully
echo.
goto :end_run
:failed_run
rem - run failed. try re-running....
rem wait 300 seconds before retrying - often a connection just needs to right itself.
ping -n 300 127.0.0.1 >NUL
echo.
echo Get Unlinked Salesreps build rerun starting
echo.
"%dmhome%\rundsjob" -P "ORACLE" %catalog% %JS% -A%dbaliases% -e%environ% -V%tracev% -L%log_file% -VDS_LOG_DIR=%log_dir% -VDS_DATA_DIR=%data_dir% -R
IF errorlevel 1 GOTO :failed_rerun
echo.
echo Get Unlinked Salesreps build Rerun completed successfully
echo.
%phome%\notify.pl +aa@hotmail.com "WARNING: Get Unlinked Salesreps build ( %environ% ) ETL" "Sent from %0 . Build succeeded, but on second try. See d:\Nexus\HR for logs"
goto :end_run
:failed_rerun
rem - run failed again. Send notice.
echo.
echo Get Unlinked Salesreps build rerun failed also
echo.
%phome%\notify.pl +aa@hotmail.com "FAILED: Get Unlinked Salesreps build ( %environ% ) ETL" "Sent from %0 . See d:\Nexus\HR for logs"
exit 1
:end_run
echo.
echo %JS% Job finished.
exit 0
Start Free Trial