How to Manage Oracle Jobs

Our Technical Support Portal has changed as we have moved to a new platform. Please visit support.quark.com to access your support tickets or to log a new ticket with us. All our existing customers should look for an email from support@quark.com for activation of their New Support Account. If you face any difficulty in accessing the new portal, please write to us at support@quark.com

How to Manage Oracle Jobs

Useful for:

  • Restoring an Oracle database to active status
  • Reinitializing QPS Server

Procedure:

  1. Log into your Oracle Schema (for DMS Server or QPS Server).
  2. Break the Oracle job. To do so:
    • Check the job id of the job with the help of the following command at the SQL prompt.
    • Select job, 'what from user_jobs;'.
    • Break the Analyze Schema job.
    • Execute dbms_job.broken(<job>,”TRUE”)
    • Restart the database.

If you want to start the job again we can execute the below command
     
execute dbms_job.break(<job>,'FALSE')

To remove the job from the Oracle database

  1. Check the job id of  job with the help of below command on SQL prompt.
  2. Select job, what from user_jobs;
  3. Execute the follwoing command:
    dbms_job.remove(<job>);
Was this answer helpful?YesNo
Topic Information
  • Topic #: 30026-1688
  • Date Created: 11/20/2012
  • Last Modified Since: 11/20/2012
  • Viewed: 1453
Welcome Guest