It is currently 23 Apr 2019 4:25

Post new topic  Reply to topic  [ 1 post ] 
Author Message
PostPosted: 28 Oct 2008 1:36 
User avatar

Joined: 27 Jul 2007 12:00
Posts: 22
Hi there,

Those of you that can help me, I would really apprciate the feedback...

And no DTS commands please, for we can not use DTSRUN, or DTEXEC

Control-M running sql stored procedures is a little bit on the difficult side without any intergration into sql from a Control Module or something in that line. When running a stord procedure, the command line interface looks like this:
isql -Uuserid -Ppassword -Q "use msdb;EXEC sp_start_job @job_name = 'JobName'"

When executing this command line, it will submit the task and it will come back saying that it has ended OK, although the store procedure is still running....

You can instead of using the -Q use a small -q, but then the task just stay in executing mode, not finishing off, for it submits the task, but it does not know what it needs back from sql to end...

Any other ideas or scripts that someone might have that may help in sorting this issue....

Kind Regards

Henk Trumpie
BMCS-SK-BMC Control-M for Distributed Systems Certified Skilled Professional.

Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 1 post ] 

All times are UTC+02:00

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by All Rights Reserved