| Troubleshooting job scheduling [message #461751] |
Mon, 21 June 2010 05:19  |
sahadba
Messages: 59
Registered: September 2009
Location: Pune
|
Member |
|
|
Hi Experts,
I had a task to reschedule database jobs to a different date as they were Running Statistics job running during business hours..
I used procedure for the same
On Thursday i.e. 17th June i changed a job as follows
exec dbms_job.change(11, NULL, TRUNC(SYSDATE+2), 'TRUNC(SYSDATE+7)');
When i checked the status today querying i found that the job was started today at 00:57 hrs.
I checked the alert logs as well but couldn't find any errors.
Please let me know how to proceed with the troubleshooting for this issue.
Thank You
|
|
|
|
|
|
| Re: Troubleshooting job scheduling [message #461780 is a reply to message #461778] |
Mon, 21 June 2010 08:10  |
sahadba
Messages: 59
Registered: September 2009
Location: Pune
|
Member |
|
|
yes i did....
I believe i have the cause known now, these jobs take 30 - 35 hrs to complete, i checked the alert logs for the next day i.e 18th and found that the database was rebooted on 18th and 20th for COLD BACKUP.
Therefore once the database is rebooted the job starts again from scratch if the job_queue_processes is not taken care of.
Quote:Metalink ID 742087.1
Therefore i believe i have to manage the scheduling of COLD BACKUP and STATISTICS job properly to avoid such issues in the future.
Thank You
[Updated on: Mon, 21 June 2010 08:12] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
