Viewing 4 posts - 1 through 4 (of 4 total)
I don't remember exactly what I did with that project years ago.
But I am sure that no need to install anything extra on AS400.
If you directly run SQLCMD from Windows...
March 4, 2013 at 2:47 pm
Here is my example:
RUNRMTCMD CMD('sqlcmd.exe -S "MY-SQL-SERVER" -Q "execute msd
b.dbo.sp_start_job @job_name = ''TestOnly'' "
...
February 28, 2013 at 12:44 pm
In fact, you can try to directly run the command on the server (your RUNRMTCMD destination) to see if it starts the SQL job.
February 28, 2013 at 10:25 am
You can add >> c:\temp.txt to redirect the command output to check if the job started successfully.
Also make sure the user is a member of SQLAgent*Role in msdb.
February 28, 2013 at 10:07 am
Viewing 4 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy