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:

DBCC CheckDB SQL Job

This job should be ran weekly or monthly. Not recommended to run daily as it can take a long time. Type: Transaction-SQL script (T-SQL) Database: master Command:

Remove Database Backup Files From SQL Job

SQL job to remove bak files older than 2 days for a folder. Type: PowerShell Run as: SQL Server Agent Service Account Command: