dba_jobs_running, sql navigator. [message #196603] |
Fri, 06 October 2006 03:03 |
SweD
Messages: 3 Registered: April 2006
|
Junior Member |
|
|
Hello,
first of all, I'm sorry if this is the wrong forum, but I didn't know where else to post.
I had an oracle job scheduled, that misbehaved and needed killing. The session was killed, and dissappeared, ora_snp process restarted, and the job dissappeard from dba_jobs_running.
The job is also not present in the advanced queueing job table.
Despite of this, when looking in the job manager of sql navigator, the job is still there, and listed as running.
Does anyone have any ideas as to where to look for this? The job needs to be rescheduled and run again, but I would certainly prefer to have it dissapear in job manager before we attempt this job again.
Any pointers in the right direction would be highly appreciated.
Regards,
/Dennis
|
|
|