Oracle Job Startup and shutdown

-- Check the job's next execution time and time interval

SELECT * from dba_jobs where job = ' 774 ';

-- Start Job

EXEC Dbms_job.run (774);

--Deactivate job

EXEC Dbms_job. Broken (job#,true);

EXEC Dbms_job. Broken (774, TRUE);

--See how many job executions are under the current user

Select Job,what,failures,broken from user_jobs where job = ' 774 ';

--View the running job

SELECT * from dba_jobs_running where job = ' 774 ';

Oracle Job Startup and shutdown