RE:Getting Job info from Dos Prompt

kris18 · Post by **kris18** » Mon Aug 11, 2008 3:07 pm

Guys,
How can we get Job info from dos script.
For example if I want to run a query like SELECT CATEGORY FROM DS_JOBS WHERE NAME="EXAMPLE".. what utility can I use..

For Example we have a dos script for exporting a set of jobs by using the "dsexport" utility..

Thanks.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 11, 2008 3:11 pm

Urgh. Given that your server is UNIX, you are in for a messy path. You need to remotely execute a dssh command with in which you can execute the SQL.

kris18 · Post by **kris18** » Mon Aug 11, 2008 5:43 pm

Ray,
Can you tell me how I need to proceed to remotely execute a dssh command..

Thanks