Defrag Index Script

uspDbaIndexDefrag xx_dba_indexDefragStatus xx_dba_indexDefragExclusion xx_dba_indexDefragLog

TSQL Parse String

Run SQL Query from CMD

Restart SQL Server from CMD

Call Another CMD

File and Folder in CMD

Variables in CMD

TestScript.cmd Result What is your name: John Specify Project?: 123 Name=John Project=123 Press any key to continue . . .

Parameters in CMD

TestScript.cmd Result D:\>TestScript 1 2 First Parameter: 1 Second Parameter: 2 Press any key to continue . . .

Error Handling in CMD

Update Statistics SQL Job

Should schedule during off hours. Type: Transaction-SQL script (T-SQL) Database: master Command: