Problem with Scheduled Jobs in Management Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Problem with Scheduled Jobs in Management Server

  1. #1
    Join Date
    Aug 2002
    Location
    Sofia, Bulgaria
    Posts
    84

    Problem with Scheduled Jobs in Management Server

    We have a lot scheduled jobs in our management server and by default they working fine. But sometimes some of the jobs have a long delay and never are completed. For example, one job which is starting at 01:45 A.M. in the morning is still with the status "Started" and never will be completed. In this case we stop the job and start it again. Then everything is okay.
    We decide to troubleshooting with the turn on logging in the management server but these logs are very unuseful.
    So, we wondering, is this bug in managements server or there is another way to debug started job and to discover what is going on.
    Thanks in advance
    Radoslav Rusinov
    OCP 8i,9i,10g DBA
    http://dba-blog.blogspot.com

  2. #2
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    If the job is a package, you could log some texts at specific moments. Do this by inserting text strings in a special table. Then you know what the package is doing.

    Maybe this helps.

    Erik
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

Posting Permissions

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



Click Here to Expand Forum to Full Width