Cancel a HPL Job?

(Using 9.40.FC6) I was running a job and lost my connection to the server. I reconnected, but the job window still shows my job running. I stopped the instance and restarted (both the source and onpload databases are in the same instance) but it didn't help. Can someone tell me how to stop this job? Thanks! Nate

Nevermind. Looks like the answer (or 'a' answer) is to just update the onpload.sessions table. After I cleared the status field, I was able to run the job. Nate On Jun 15, 6:53 pm, nate...@gmail.com wrote: > (Using 9.40.FC6) > > I was running a job and lost my connection to the server. I > reconnected, but the job window still shows my job running. I stopped > the instance and restarted (both the source and onpload databases are > in the same instance) but it didn't help. > > Can someone tell me how to stop this job? > > Thanks! > Nate