How to Deal with Jobs Belonging to Other Users

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

FAZ