Finding a job

Prashantoncyber · Post by **Prashantoncyber** » Tue Oct 31, 2006 1:04 am

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

kumar_s · Post by **kumar_s** » Tue Oct 31, 2006 3:26 am

There is a command available called 'dssearch' from command prompt.

talk2shaanc · Post by **talk2shaanc** » Tue Oct 31, 2006 6:39 am

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.