DSXchange

How I can get logs (Status alone will also work) for datastage jobs ran today/yesterday. Please note that jobs are running with invocation Id (Multiple instance jobs).

The easiest way is to use DataStage Director client, which includes a Print option (and, from that, a Print to File option). Director can open separate invocations' logs separately.

If you want to use a programmatic approach, then you will need to organize the filtering by date and by invocation ID. But it's certainly doable.

But Datastage Director client will also give the jobs which didn't ran today.
Basically I want to create a report in customized format and automate this process.
We can do this using dsjob command with -linvocations but this gives all invocation ids irrespective of date. I am just interested for a particular date not all.

What information are you obtaining from the log?
Perhaps the DSODB database can be your source of info.

As of now, I am interested in Job Start time, End time and Job status.
Please elaborate how I can access DSODB database to get this information. If possible, in detail please.

For DSODB connection information, give your DataStage admins a visit

How to use DSODB:
https://www.ibm.com/support/knowledgece ... ryodb.html