DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Purge job

  1. 10-13-2003, 12:28 AM #1
    dxb
    dxb is offline Junior Member
    Join Date
    Jul 2003
    Location
    Dubai, UAE
    Posts
    15

    Purge job

    hi,

    How can I change the time interval for the PURGE job in Replication. I dont want to use OEM. Kindly if some one knows the sql statement to do that.
    Reply With Quote Reply With Quote
  2. 10-13-2003, 12:59 AM #2
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Purge job

    Originally posted by dxb
    hi,

    How can I change the time interval for the PURGE job in Replication. I dont want to use OEM. Kindly if some one knows the sql statement to do that.
    EXECUTE Dbms_Defer_Sys.Schedule_Purge( -
    next_date => sysdate+1/24, -
    interval => 'sysdate+1/24');

    This purge?

    If so, then find the job number and use: DBMS_JOB.INTERVAL
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  3. 10-14-2003, 02:05 AM #3
    dxb
    dxb is offline Junior Member
    Join Date
    Jul 2003
    Location
    Dubai, UAE
    Posts
    15
    Thanks alot
    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

Click Here to Expand Forum to Full Width