|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
reset job from broken to normal
Hi,
I have submit a job using DBMS_JOB. This job will execute a stored procedure every 5 minutes. Then i mark the job as broken. After mark the job as broken, i reset the broken job to normal immediately. Found that the job is run after i reset it back to normal. Actually i expect it will start after 5 minutes. Am i missing something? Or this is the feature of DBMS_JOB? Is is true that after reset the job to normal, it will run immediately? What is your experience after reset the job from broken to normal? Regards, |
|
#2
|
|||
|
|||
|
Hi,
it suppose to run since when you move a job into a broken state the next time it suppose to run remains the same (let say 10Am) and when you mark it as unbroken again after 10 minutes the next time had passed so it will run immediatly. this behaviour will also happen if you stop the db and than start it after the job was supposed to run. hop that helps. Galit. |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > reset job from broken to normal |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|