DSGetJobInfo to execute in a shell script

Amit_111 · Post by **Amit_111** » Sat Sep 13, 2008 8:22 am

Hi All,

I want to execute the commands "DSGetJobInfo", "DSGetLinkInfo" through Unix shell script to get information like "StartTime" "EndTime" and records passed throuh the links of a particular job.
I further want to get the output of these functions in a variable in shell script and directly insert the output in an Oracle table through the same shell script

I tried executing these commands but was not successfull.
Please let me know if it is possible and if their is any alternate command to be executed in Unix which will give me the same output as that of "DSGetJobInfo", "DSGetLinkInfo"?

Thanks in Advance.

chulett · Post by **chulett** » Sat Sep 13, 2008 8:41 am

Check the various options for 'dsjob', there are equivalents there for all of the functions you can use in jobs. Server Job Developer's Guide, Command Line Interface chapter or the usage help in dsjob itself.

For example: dsjob -jobinfo

ray.wurlod · Post by **ray.wurlod** » Sat Sep 13, 2008 4:01 pm

DSGetJobInfo() and its ilk are not commands - they are DataStage BASIC subroutines. They are not directly invokable from the operating system.

The dsjob command provides some, but not all, of the functionality.

There is a C-callable DataStage API that you can use (in your own C code).

You can also do the whole thing within DataStage, including insertion into the Oracle table.

Even better, that particular wheel has already been invented. Download ETLstats from Kim Duke's website

Amit_111 · Post by **Amit_111** » Wed Sep 17, 2008 9:29 am

Thanks Craig and Ray for your valuable pointers.
I could get the link Information through dsjob in the Unix Shell script.