Executing batch file from sql server job

Posted by uzay95 on Server Fault See other posts from Server Fault or by uzay95
Published on 2010-05-25T12:32:41Z Indexed on 2010/05/25 13:02 UTC
Read the original article Hit count: 228

Filed under:
|

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)

© Server Fault or respective owner

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: 228

Filed under:
|

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

Related posts about batch

Related posts about sql-server