There is a requirement for me open up multiple sessions of same HP Unix Host server. I just automate this using simple DOS Batch file below;
| @echo off start /max C:\Windows\System32\putty.exe -load "D1- Session1" -l %uname% -pw %pwd% @echo on |
| echo off set filename=F:\Sivaprasad\Error%time:~0,2%%time:~3,2%%time:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4%.txt echo %filename% |
Requirement:
To Search the given files under current directory for given strings. If anything found to be written to a file.
Sample Screen:
Main Script: CHK_Error.bat
| @echo off set fname= IF %1. NEQ . (set fname="C:\Accounts\CalWIN\Build\SQLServer\DOS_Batch\%1*.lst") ELSE ( GOTO _Usage ) for /F "tokens=2-4 delims=/ " %%i in ('date /t') do set yyyymmdd=%%k%%i%%j for /F "tokens=1-2 delims=: " %%l in ('time /t') do set hhmm=%%l%%m set filename=Error_%yyyymmdd%%hhmm%.txt echo "Error Log file name is : " %filename% echo "files to be searched : " %fname% findstr /i /n /g:search.txt %fname% > %filename% if %errorlevel% == 0 (GOTO :_Error_Found ) else ( :_Error_Found :_Usage :END |
Search.txt
| msg |
Input Files: file1.lst
| dgadagdagad st messgae adgadg agadgadgadadadsflmsvbkobsagad dgadgadg dgad gadagad gagad msg 128, 9341353513 |
Input Files: file2.lst
| test messgae dgadgadg dgad gadagad gagad msg 128, 9341353513 |
By using the SET the environment value persist till the current session live.
To set the environment value permanent in DOS use the SETX
To delete te
--Delete all .bak files in the named directory and its subfolders where the file modified date is more than 2 days old.
| EXEC xp_cmdshell 'FORFILES /p "L:\MSSQL$PRODSQL2KWEB\Backup" /s /m *.bak /d -2 /c "CMD /C echo Deleting the file : @file del /Q /F @FILE && del /Q /F @FILE " ' |
/*
FORFILES Parameters
Parameter Name Description
/p Path
/m Search Mask (default is *.*)
/s Subdirectories will be searched recursively if this parameter is included
/c <command> Command to be executed against each file in the result set, commands must be enclosed in double-quotes, default is "cmd c/ echo @file"
/d Date range for file selection, using Last Modified Date as the criterion for the file. When the /d parameter is in the form of MM/DD/YYYY, file meeting the criteria of +/- the specified date are included. When in the format of a smallint (-32,768 - 32,768) the files +/- the files with a modified date +/- that number of days from the current date are included in the file result set.
Variables
Variable Name Description
@FILE File name
@FNAME File name without extension
@EXT File extension
@PATH Full path of the file
@RELPATH Relative path of the file
@ISDIR Evaluates as TRUE if the file type is a directory
@FSIZE File size in bytes
@FDATE Last modified date stamp on the file
@FTIME Last modified timestamp on the file
*/
| declare @IDENT INT, @sql varchar(1000), @DBNAME VARCHAR(200)
select @IDENT=min(DBID) while @IDENT is begin SELECT @DBNAME = NAME FROM /*Change disk location here as required*/ SELECT @SQL = PRINT @SQL EXEC (@SQL) select @IDENT=min(DBID) end |
| @echo off c: if not exist c:\SQLBackup\Logs MD C:\SQLbackup\Logs if not exist c:\SQLBackup\Backup MD C:\SQLbackup\Backup cd c:\SQLBackup Echo Backup Started >> c:\SQLBackup\Logs\SQLBAckup.log Date /T > c:\SQLBackup\Logs\SQLBAckup.log Time /T >> c:\SQLBackup\Logs\SQLBAckup.log Echo. echo *************************************************************************** >> c:\SQLBackup\Logs\SQLBAckup.log isql -S (local)\Express -E -i c:\sqlbackup\backup.sql >> c:\SQLBackup\Logs\SQLBAckup.log echo *************************************************************************** >> c:\SQLBackup\Logs\SQLBAckup.log echo. Date /T >> c:\SQLBackup\Logs\SQLBAckup.log Time /T >> c:\SQLBackup\Logs\SQLBAckup.log echo Backup Finished >> c:\SQLBackup\Logs\SQLBAckup.log echo. echo *************************************************************************** >> c:\SQLBackup\Logs\SQLBAckup.log |
Folders will look like,
Schedule it on Windows Task Scheduler
That's it the SQL Server 2005 / 2008 Express Edition database backup is automated now!
