SQLServerCentral / Connecting / Programming / Run SQL Server Job from Command Line / Latest Posts

RE: Run SQL Server Job from Command Line

vconlan — Tue, 26 Feb 2013 08:54:30 GMT

I am trying to use the same command and I am having trouble getting it to work. I am running this: RUNRMTCMD CMD('sqlcmd -U user -P password -S server name -Q "msdb.dbo.sp _start_job @job_name = ''FACT852: ProcessRetailSales'', @server_name = '' server''"') RMTLOCNAME('99.99.99.99' *IP) RMTUSER(user) RMTPWD(password)

RE: Run SQL Server Job from Command Line

Bob Bridges-173967 — Fri, 23 Mar 2007 08:24:00 GMT

I got this to work using the sa account but not when I run it with a SQL Server account. I gave rights to the SQL Server account to execute the stored procedure as well as the sp_start_job stored procedure.

Any ideas how I can get a generic SQL Server account to work?

Thanks,

Bob

RE: Run SQL Server Job from Command Line

Bob Bridges-173967 — Wed, 21 Mar 2007 15:54:00 GMT

Adam, I figured it out... in your example change the small q to a captial Q

Thanks again, Bob

RE: Run SQL Server Job from Command Line

Bob Bridges-173967 — Wed, 21 Mar 2007 15:20:00 GMT

Thanks Adam... I had to tweak it just a bit but it works. One further question... when I run this from a command prompt, after it starts, there is a message that the command "started successfully." Then the next line looks like this...

If I press the enter key it simply adds a >2 below that.

Does this mean the system is waiting on something to get me back to a regular command prompt?

Thanks again,

Bob

RE: Run SQL Server Job from Command Line

Adam Angelini — Wed, 21 Mar 2007 13:59:00 GMT

use either osql or sqlcmd, depending on your version of SQL (2000 uses osql, 2005 is sqlcmd)you can use that to run sp_startjobso your command may look like this:osql -E -SserverName -q"sp_start_job @job_name = 'job_name', @server_name = 'server_name'"

Run SQL Server Job from Command Line

Bob Bridges-173967 — Wed, 21 Mar 2007 12:16:00 GMT

Good afternoon,

I need to daisy chain a SQL Server job with an AS400 job (have the AS400 job kick off the SQL Server job). I've been told that this can be done but how do I do this? What connectivity do I need and more pressing right now, what is the command line syntax for such a job?

thanks,

Bob