Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011

    Unanswered: dbms_scheduler_job disabled after running

    I have the user 'ORAASFS' and it has some batch dbms_scheduler_job that is delete old record base on date and data size.
    this is running everyday almost midnight and running well.
    The problem is if I check in the afternoon about these 'jobs' every 'jobs' is disabled and I have to enable by hand all the 'scheduler jobs'. I think normal it is fine and on some days it is disabled by some other factor.

    What can be disable 'scheduler job' on specific day?
    Or is it disabled after it running OK?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >What can be disable 'scheduler job' on specific day?
    >Or is it disabled after it running OK?

    you have a mystery & we have NO clues.
    post SQL & results that show this job is disabled.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2011

    I found about option

    I put the max runs and max failures parameter to my scheduler jobs.
    I think I put both then resulted disabled after specific running time.

    I removed max runs and changed to 0, that mean unlimited.
    and I will see if it's disabled.
    if it doesn't over to max failures, I guess I will fine about scheduler jobs.

    Thank you.
    Some times asking is compromise my thinking and I figure it out what I was wrong.
    I hope this scheduler job article is helpful to you.

    Thank you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts