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