DSXchange

I am sure its do-able. Just like any other webservice call. I did not follow up much with it. But my system architect was really into it and gave IBM a call. They tried to explain to him how it can be done. So its not that its impossible. I can't ask my architect as he is not with this client any mo...

Can you execute the job from command line? If yes then use the exact syntax, using fully qualified names.

Oracle enterprise stage is not available for server jobs.

As I mentioned, a lot of ways

There are several ways. One of them is

This error, basically tells you that there was a communication problem between your oracle client and database. For more info, search on the error code in google. Like this for instance.

Any particular reason why you dont want to use an after job subroutine for this? as that will be the most feasible and clean design.

Try thispost.

Can you be more specific? Your query is vague.

Well, the question arose at my present client for it, but we choose a different path. We are using Blue Wolf (a replicating tool) that replicates the data to oracle tables and we source these tables.

Well, you will have to get the eventid before the job starts, store it somewhere (COMMON, USERSTATUS, FLAT FILE etc) and get the last even id and then loop through each while getting the log detail.

Welcome Aboard
Please search on 'DSR_EXECJOB'. This issue has been covered before.

What is your job design? The error seems to be coming from ftp stage and not from sequential file stage.

You not able to see any stats bacause your JobMonApp is failing to startup. Do an exact search on keywords 'Failed to discover JobMonApp port' to see how others tackled the issue.

More like, DSGetLogEntry() which works along with DSGetNewestLogId(). Look in the help index for DSGetLogEntry(), it will explain you how to use it. You will then have to create your own after job subroutine that uses these api calls.