Extracting JOB_ID for WebClient via webservice

[Former Member]

Here is the scenario:

- A webclient executes a job via a webservice

- Some jobs can take hours

- Webclient would like to incorporate a log/status screen that allows a "refresh" on the status of executed BODI jobs... this feature would be outside of BODI using a custom web interface

- I previously found that there is no internal BODI function to get JOBID

Question:

How do I pass back the job_id to the webclient for the job that has been executed? Is this allowed through the webservice?

Assumption:

I assume that the webclient can query the log tables against the status of the referenced JOBID ? Or is there a better way to do this ?

Edited by: Lester Mendoza on Nov 18, 2008 10:30 PM

Edited by: Lester Mendoza on Nov 18, 2008 10:30 PM

[Former Member · Accepted solution]

In Data Services there are few more operations added WebServices related to Batch Job administration, if you are using DS XI 3.0/3.1 check if you can use those to acheive this

[Former Member · Accepted solution]

I should have mentioned... I am currently running 11.5.5... can this be done with that version?

[Former Member · Accepted solution]

any other suggestions?

[Former Member · Accepted solution]

you can query the ALVW_HISTORY view, the name of Job is stored in SERVICE_NAME column, to get the latest execution check for the END_TIME IS NULL or select the MAX (START_TIME), using JDBC from the external application

Or you can create a real time Job, and publish that as real time service, send the job name in the input xml and do a join on ALVW_HISTORY to get the status and return information in the output XML . You can build the above logic in that real time job, call that real time service to get the status and format the output from the return XML

This would be similar to what its doing in XI 3.0 without the overhead of Real time service.

[Former Member · Accepted solution]

In our case, we have the following requirements:

Web Client calls a batch job.

We do not want the webclient to continually call the DI WebService to check the status of the job. So, when the DI job is finished, as the last step, we would like the job to call a web service to indicate that it finished (or failed in a Catch block).

To support this, we would like to pass the Job ID as a parameter to this Web Service (theoretically, there could be multiple instances of the same job running parallely, so the name would not be enough).

Any ideas how we can get the Job ID in the job, or support the above requirements?

Thanks,

Sandeep