Fetch all the jobs with a particular job owner

[Sowmya KeshavaMurthy]

Hi, 
I am trying to fetch all the jobs in my database which have a particular "owner" on the job.

I am trying to use the below query but I receive the error as "
ERROR at line 1:
ORA-00904: "OWNER_NAME": invalid identifier jobs are Scheduled to run on STA for owner"

Can anybody please help me?

SELECT j.job_name FROM ujo_job j, ujo_owner o where j.owner_name = o.parent_name AND o.owner_name = '$OWNER' AND is_active=1 AND j.is_currver=1;

------------------------------
Regards,
Sowmya. K
------------------------------

[Daniel Shannon]

Not that I encourage anyone to access the AutoSys database directly, but if change the query to simply filter by the owner column in the ujo_job table you should be able to get what you want. I'm not sure what's in the the ujo_owner table because that is not one we define.

------------------------------
Broadcom - CA Technologies
------------------------------

[Sowmya KeshavaMurthy]

Thanks Daniel. I was able to get that right.
Thanks again.

[Joe Poutre]

Hello Sowmya,

This can be done from WCC, too, using the QuickEdit too.

Regards,
Joe Poutre