cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Bookmark
|
Subscribe
|
1370
Views
0
Helpful
1
Replies

How to view Tidal Job output in a query?

DCRICTAdmin
Level 1
Level 1

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 1

fintan.halpenny
Level 1
Level 1

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 :)

Review Cisco Networking for a $25 gift card