Scheduler Usage

Hi All,

One quick question..

I have a batch file where in it executes a Stored Procedure.

Can we get the result of this Stored Procedure in SYSOUT...?

Thanks

Ravi

Whatever written to STDOUT and STDERR will go into SYSOUT. Check your batch script and in the stored procedure if these two output channels have been redirected else where.

Hi,

Thanks for the inputs.

How do I check whether my STDOUT & STDERR have been redirected or not..?

Can you please make it clear with an Example.....

if you are sendig the stored procedure output to a file you can use cat (unix) or type (windows) to append SP output to sysout.

regards
martin

If you are on CONTROL-M EM 6.4.01 Fix Pack 2 or above, with CONTROL-M Server and Agent 6.3.01 Fix Pack 2 and above, you can use the new CONTROL-M for Databases feature. this allows you to run native SQL, SQL scripts and stored procedures against MS SQL, Oracle and DB2/UDB databases without the need for wrapper scripts, and can also capture your output into the CONTROL-M SYSOUT.

Regards.

Graham

Hi… that was great stuff..


sahiwal Boards Results 2014

This was really some nice information for scheduler users. I am glad to read it here and thanks for sharing