Page 1 of 1

Finding a job

Posted: Tue Oct 31, 2006 1:04 am
by Prashantoncyber
Hi All,

How to search/find a particular job in datastage project?
I tried to use seach option in Director.but its not working.

thanks

Posted: Tue Oct 31, 2006 3:26 am
by kumar_s
There is a command available called 'dssearch' from command prompt.

Posted: Tue Oct 31, 2006 6:39 am
by talk2shaanc
or login to datastage administrator and on "command" ; run below sql

SELECT * FROM DS_JOBS WHERE @ID LIKE '<job name>';

Its case sensitive, so if you are not aware of exact cases used in the job name; use UPPER function.