Kill linux job Processes

Today, the JOB process that kills LINUX finds that a JOB in the database has been being executed for several hours. Therefore, we have to delete the system environment www.2cto.com: the procedure for operating the ORACLE 10G Linux operating system is as follows: Step 1. the job is running. Find the corresponding SID field. SQL code select * from dba_jobs_running -- find the sid corresponding to the job. Step 2. use the following statement to query the SPID corresponding to the SID. SCHEMANAME = '# username #' indicates the name of the user running the JOB, SID = 342 is the SID code previously queried. SQL code select * from gv $ process s, Gv $ session gn where s. ADDR = gn. PADDR and gn. STATUS = 'active' and gn. SCHEMANAME = '# username #' and sid = 342 -- find step 3 of spid corresponding to this sid. in command line mode, the following code is allowed, where 1622202 is the SPID text code kill-9 1622202 -- kill the process.