Home > Database > Mysql Tutorial > How to start a DB job by batch file

How to start a DB job by batch file

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 15:49:01
Original
1166 people have browsed it

Copy below code into atext file, and modify the extension name from txt to bat. ECHO Executing job ECHO. pause osql -U User_ID -P Password -S Server_IP -Q EXEC msdb.dbo.sp_start_job 'DB_Job_Name' ECHO job execution completed pause CLS EXIT

 Copy below code into a text file, and modify the extension name from txt to bat.

 

ECHO Executing job
ECHO.
pause
osql -U "User_ID" -P "Password" -S "Server_IP" -Q "EXEC msdb.dbo.sp_start_job 'DB_Job_Name' "

ECHO job execution completed
pause
CLS
EXIT

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
How to learn php well
From 1970-01-01 08:00:00
0
0
0
How to write a loop?
From 1970-01-01 08:00:00
0
0
0
How to run/debug your PHP code?
From 1970-01-01 08:00:00
0
0
0
How to sign up?
From 1970-01-01 08:00:00
0
0
0
How to save online editor
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template