Results 1 to 4 of 4

Thread: search for submitted jobs

  1. 07-14-2003, 11:44 PM #1
    prasen999
    prasen999 is offline Registered User
    Join Date
    Jul 2003
    Location
    India
    Posts
    8

    search for submitted jobs

    hi,
    i have submitted a job, but i have forgotten the job no, then how do i remove the job from the queue, which table holds this information.

    thanks,
    prasen
    Reply With Quote Reply With Quote
  2. 07-15-2003, 01:30 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    http://www.dbasupport.com/oracle/ora9i/jobqueue2.shtml
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-15-2003, 11:42 PM #3
    prasen999
    prasen999 is offline Registered User
    Join Date
    Jul 2003
    Location
    India
    Posts
    8
    hi Mak,
    thanks a lot. but when i try to change the job interval, it says the procedure has been executed successfully; but when i query the dba_jobs table the change is not reflected.


    regards,
    Prasen
    Reply With Quote Reply With Quote
  4. 07-16-2003, 12:15 AM #4
    prasen999
    prasen999 is offline Registered User
    Join Date
    Jul 2003
    Location
    India
    Posts
    8
    hi,
    when i gave a commit command and checked, the interval was changed. but i had the idea that procedures do not have to be committed after execution.

    thanks,
    Prasen
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules