Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

How to view Tidal Job output in a query?

I am using a query to extract the standard output of a job:

select jobrun_id, dbms_lob.substr( jobrun_output, 4000, 1 ) 
from tidal.joboutput
where  jobrun_id = 686361;

The query returns output in an XML format:

<TESXOUTPUT><MSG>Job output data is in XML format. To view job output upgrade your Client to latest version.</MSG><OUTPUT COMP="Y" RUN="1">eJzFVltv2zYUftevOBhQpB1CxXZuDQMXkC9...

How can I translate this output into readable text?

Thanks.

1 REPLY
New Member

I was running the REST api

I was running the REST api command to get the job output and received the same result as you. I found a method in the documentation that allows you to get the output in readable form.

Here it is:
JobOutput.getOutputContent/id

 

where id is the job run id

Hope that helps :)

237
Views
0
Helpful
1
Replies