Create .bat files to execute php files.
@echo off
echo Generating AdHoc Report…..please wait
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\ReportTCO.php
echo Report TCO Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\reportProblemTypeDL_NotClose_new.php
echo Report Problem Type Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\ReportDisposition_Daily_new.php
echo Report Disposition Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\reportPenghapusan-Pengembalian_new.php
echo Report Penghapusan-Pengembalian Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\CloseAndReplyCSC_new.php
echo Report Close-Reply CSC Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\Report_All_Pending_PerDepartment_new.php
echo Report monthly Pending All Department Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\Report_All_Pending_New.php
echo Report All Pending Department Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\progress_jkt_New.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\progress_bdg_New.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\progress_smg_New.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\progress_sby_New.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\progress_medan_New.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\SummaryTHDReport_New.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\DailyTHDCreate_New.php
echo Report THD Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\Report_Daily_Dismantling.php
echo Report Dismantling Created ..
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\ReportLewatBatasSLA_new.php
echo report escalation Over SLA created ..
echo Copy Report to Shared Folder…
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\CopyReport.php
echo Generating Report Completed………….
echo Starting Send E-mail……
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\Daily#SendAdHocReport.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\Weekly#SendAdHocReport.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\monthly#SendAdHocReport.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\Daily#SendTHDReport.php
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\Daily_SendDISMANTLINGvsTHD.php
Sending E-mail Finished ..
Create .bat files to Backup Database with mysqldump.
C:\Server\xampp\mysql\bin\mysqldump -u root astro > d:\BackUp_Dump_Database_for_Veritas\dump_astro.sql
C:\Server\xampp\mysql\bin\mysqldump -u root dbbilling > d:\BackUp_Dump_Database_for_Veritas\dump_dbbilling.sql
C:\Server\xampp\mysql\bin\mysqldump -u root dbglobal > d:\BackUp_Dump_Database_for_Veritas\dump_dbglobal.sql
C:\Server\xampp\mysql\bin\mysqldump -u root dbretention > d:\BackUp_Dump_Database_for_Veritas\dump_dbretention.sql
C:\Server\xampp\mysql\bin\mysqldump -u root dbstat > d:\BackUp_Dump_Database_for_Veritas\dump_dbstat.sql
c:\Server\xampp\mysql\bin\mysqldump -u root dbtco > d:\BackUp_Dump_Database_for_Veritas\dump_dbtco.sql
c:\Server\xampp\mysql\bin\mysqldump -u root dbvoucher > d:\BackUp_Dump_Database_for_Veritas\dump_dbvoucher.sql
c:\Server\xampp\mysql\bin\mysqldump -u root dbwaiver > d:\BackUp_Dump_Database_for_Veritas\dump_dbwaiver.sql
c:\Server\xampp\mysql\bin\mysqldump -u root dbhbo > d:\BackUp_Dump_Database_for_Veritas\dump_dbhbo.sql
Create .bat files to restore Data Base.
c:\Server\xampp\MYSQL\bin\mysql -u root dbbilling < D:\BackUp_Dump_Database_for_Veritas\dump_dbbilling.sql
Copy backup of result files to another location (drive or directory).
@echo off
echo Copy Dump Database Files…..please wait
C:\Server\xampp\php\php.exe C:\Server\xampp\htdocs\main\escalation\report\CopyBackupDatabase.php
