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
------------------------------