Executing batch file from sql server job
- by uzay95
I want to create backup job on sql server. And i want to execute batch file in job. I just wonder the part of executing batch file from sql job. Do you have any idea?
Any help would appreciated.
use MyDb
go
BACKUP DATABASE MyDb TO DISK = 'C:\BackUps\MyDb.bak' WITH differential
go
-- Call my batch file (which will zip MyDb.bak file)