DBA JOBS

[stef]

Hi All,

Problem with USERNAME/ SCHEMA
I cannot see the DBA_Jobs any more if I logged in as diffrent user. Even if I have access to this user/ schema and change the user it is not possible to see the dba_jobs in the Object Browser, the list is empty.

In version 9.0.2.1621 it is possible but not in 9.0.6.1665.
Is there a workaround will this be fixed??

And my last question, is it possible to get information ('What') about the Job in the Object Browser.

thx a lot

Stef

 

[Marco Kalter]

Are you looking at the "Jobs" folder or the "DBMS_Jobs" folder? You should use the latter one.

The "what" information cannot be displayed in the Object Browser.

 

[stef]

Thx for the quick response, but this is not working.

I can not see anything in Jobs or in DBMS_Jobs (mean DBMS_Jobs).
We have to use the DBMS_Jobs. When I logon to the schema then I can see everything.

So problem is, I have access to schema B but I have to logon ( user right policy) to schema A. Checking then the jobs with set the schema to B, I cannot see anything in DBMS_Jobs, also it is not possible to use F5 Explain, you will see nothing.

 

[Marco Kalter]

Can you check if it helps if you change the user selector of the object browser to ?

 

[stef]

Hi Marco,

Does not help, no result found with ,

br,

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).