<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Programming
»
Connecting
»
Execute a sql job from AS400 command line
14 posts, Page 1 of 2
1
2
»»
Execute a sql job from AS400 command line
Rate Topic
Display Mode
Topic Options
Author
Message
vconlan
vconlan
Posted Tuesday, February 26, 2013 8:58 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, March 05, 2013 6:28 AM
Points: 7,
Visits: 9
I am trying to use this command to execute a sql job from an AS400 command line. I am having trouble getting it to work. It doesn't say that the job started. It just says 'The remote command has produced no output'.
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)
Post #1424127
Gift Peddie
Gift Peddie
Posted Wednesday, February 27, 2013 10:45 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432,
Visits: 14,332
vconlan (2/26/2013)
I am trying to use this command to execute a sql job from an AS400 command line. I am having trouble getting it to work. It doesn't say that the job started. It just says 'The remote command has produced no output'.
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)
I have not used it for a while but you can use stored procedure to execute the job but admin permission is required for both SQL Server and AS400.
Kind regards,
Gift Peddie
Post #1424649
vconlan
vconlan
Posted Wednesday, February 27, 2013 11:01 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, March 05, 2013 6:28 AM
Points: 7,
Visits: 9
I have and EDI process on my AS400 and at the end of that process I need to call a sql job. However we can't get it to work.
Post #1424656
Gift Peddie
Gift Peddie
Posted Wednesday, February 27, 2013 11:21 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432,
Visits: 14,332
vconlan (2/27/2013)
I have and EDI process on my AS400 and at the end of that process I need to call a sql job. However we can't get it to work.
Then you can create SSIS package that can run both or create a job steps that runs both.
Kind regards,
Gift Peddie
Post #1424665
thsu
thsu
Posted Thursday, February 28, 2013 10:07 AM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 1:26 PM
Points: 4,
Visits: 32
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.
Post #1425162
vconlan
vconlan
Posted Thursday, February 28, 2013 10:14 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, March 05, 2013 6:28 AM
Points: 7,
Visits: 9
I'm sorry I am confused.
I need to initiate this on the aS400. I am trying to use this command. Does this command not work?
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)
Post #1425170
thsu
thsu
Posted Thursday, February 28, 2013 10:25 AM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 1:26 PM
Points: 4,
Visits: 32
In fact, you can try to directly run the command on the server (your RUNRMTCMD destination) to see if it starts the SQL job.
Post #1425174
Gift Peddie
Gift Peddie
Posted Thursday, February 28, 2013 11:12 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432,
Visits: 14,332
thsu (2/28/2013)
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.
That will not work for IBM AS400 because since 2005 admin permissions in both IBM and Microsoft is required for most automation solutions to work.
Kind regards,
Gift Peddie
Post #1425213
thsu
thsu
Posted Thursday, February 28, 2013 12:44 PM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 1:26 PM
Points: 4,
Visits: 32
Here is my example:
RUNRMTCMD CMD('sqlcmd.exe -S "MY-SQL-SERVER" -Q "execute msd
b.dbo.sp_start_job @job_name = ''TestOnly'' "
>> C:\temp\temp.txt')
RMTLOCNAME('MYPC.THSU.COM' *IP)
RMTUSER('thsu')
RMTPWD('mypassword')
Results in temp.txt:
Job 'TestOnly' started successfully.
TestOnly job history showed "The job succeed"
Hope this helps.
BTW, I use Windows Authentication in SQL server.
-Tom
Post #1425258
vconlan
vconlan
Posted Thursday, February 28, 2013 12:49 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, March 05, 2013 6:28 AM
Points: 7,
Visits: 9
Thanks I will see how this works.
Post #1425261
« Prev Topic
|
Next Topic »
14 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
