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, and broken.
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. Where might sql navigator pick up that this job is running?
Any pointers in the right direction would be highly appreciated.