How to Deal with Jobs Belonging to Other Users
Jul 16, 2012 / By Fabio Zea
So this is my first official entry on my brand new blogging account.
I kept postponing doing this, as I was always too busy to blog with something more important to do.
Anyways, today I ran into this issue and figured that it was a good time as any to get started blogging.
So without further ado here it its….
This is not the first time I have run into this issue – in the past I (and who knows how many more Oracle DBAs) have had to deal with handling jobs from a different user, which usually ends up with a big:
And of course, we don’t know the password for the real owner of the job….
So first, we identify the real owner of the job (select job, schema_user from dba_jobs)
Second, we figure out a way to connect as the real owner, and let dbms_job do the magic.
However, when you are dealing with several clients/db_users/databases there isn’t always time to find a way to connect with the owner and use dbms_job.
The answer to my prayers was the undocumented dbms_ijob package, which lets me, as a DBA, deal with jobs from other users.
I don’t need to elaborate on the usage of dbms_job, if you’re here it means you have already used it and played with it.
From what I have experienced so far, the dbms_ijob package can be used the same way that you would use dbms_job, so have fun with it.
Until my next post….