Results 1 to 2 of 2

Thread: Clear queue

  1. #1
    Join Date
    Mar 2011
    Location
    Poland
    Posts
    21

    Question Unanswered: Clear queue

    Hi,

    What is a command that will clear all data from queue on replication server?
    I know that it exists but I don't remember how it goes :/

  2. #2
    Join Date
    Mar 2011
    Location
    Poland
    Posts
    21
    So I will reply myself:

    Purges all messages from a stable queue.
    Syntax:
    sysadmin sqm_purge_queue, q_number, q_type

    Parameters:
    q_number, q_type

    Identifies the stable queue to be purged. Find these using admin who, admin who, sqm, or admin who, sqt.

    Example:

    Purges all messages from inbound queue number 103:

    sysadmin sqm_purge_queue, 103, 1

Posting Permissions

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