Executing batch file from sql server job
Posted
by uzay95
on Super User
See other posts from Super User
or by uzay95
Published on 2010-05-25T12:32:41Z
Indexed on
2010/05/25
12:32 UTC
Read the original article
Hit count: 251
batch
|sql-server
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)
© Super User or respective owner