Re: select * from all_jobs returns no row?

From: Malik Michael <mmalyk_at_cryptologic.com>
Date: Fri, 03 Nov 2000 11:36:42 -0500
Message-Id: <10669.121089@fatcity.com>

Hi Guang !

Both of them (ALL_JOBS,USER_JOBS) are public synonyms of 'user_jobs' view and have the same meaning. Look at this statement from $ORACLE_HOME/rdbms/admin/catjobj.sql
script:

....................

create or replace view USER_JOBS
as select j.* from dba_jobs j where j.priv_user = USER; /
comment on table USER_JOBS is
'All jobs owned by this user'
/

...................

drop public synonym USER_JOBS
/
create public synonym USER_JOBS for USER_JOBS /
grant select on USER_JOBS to public with grant option /
drop public synonym ALL_JOBS
/
create public synonym ALL_JOBS for USER_JOBS /
grant select on ALL_JOBS to public with grant option /

I've got the same result for both SELECT queries: SELECT * FROM user_jobs;
SELECT * FROM all_jobs;

Environment: RDBMS ORACLE 8.0.5

Michael Malyk
Oracle Programmer
Toronto, Canada
mmalyk_at_cryptologic.com

Guang Mei wrote:

> Hi:
>
> A qucik question about "all_jobs".
>
> I got no rows returned when issuing:
>
> select * from all_jobs ;
>
> I can view the jobs by using "user_jobs" and "dba_jobs". Oracle
> documentation does not mention "all_jobs". Here is part of the doc:
>
> ----
> You can view information about jobs in the job queue via the data dictionary
> views in Table 8-6:
>
> Table 8-6 Views for Job Queue Information
> View Description
> DBA_JOBS
> Lists all the jobs in the database.
>
> USER_JOBS
> Lists all jobs owned by the user.
>
> DBA_JOBS_RUNNING
> Lists all jobs in the database that are currently running. This view joins
> V$LOCK and JOB$.
> ------
>
> But if I do "desc all_jobs" I can see all the columns. So what does this
> "all_jobs" do then?
>
> TIA
>
> Guang
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Guang Mei
> INET: zlmei_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Nov 03 2000 - 10:36:42 CST