Terminate the scheduled execution job.

[islandfong]

I have a list of job scheduled to be executed in sequence with Oracle 10g. Each of these jobs could take quite a long time to run. Eventually user may decide to terminate the execution of the job in the middle. I don't want this termination action to impact the other jobs scheduled. Can I use 1 session for each job executed and terminate the session when user wants to terminate the job? If yes, I will have many sessions for these jobs in the Oracle server. How can I know the session of the job?
Thanks.

[debasisdas]

Hi

You can get the details from DBA_JOBS_RUNNIN G.,


Hope it helps you