Scheduling extraction queue deletion

[former_member185837]

I need to delete the extraction queue's content, before filling the setup table.

While I can schedule the setup job, I can't schedule a job for deleting the queue. I'd like to schedule both the deletion of an extraction queue and the setup job. The start condition for the setup job would be the end of the deletion job.

I'm annoyed at waiting midnight just for deleting the extraction queue with LBWQ...

But what's the name of the report for deleting a particular extraction queue (e.g. for application 13, invoicing)?

Cheers, Davide

[Former Member]

Davide,

program name is RMCSBWSETUPDELETE.

Create variant for your application 13 for this program and schedule.

RC

[former_member185837]

Hi Ravi,

the program RMCSBWSETUPDELETE clears the setup table. I have no trouble with deleting the setup table. In fact I can delete it at whatever time.

Instead I need the program which deletes the <b>extraction queue</b> (for e.g. application 13).

Thanks,

Davide

[former_member185837]

I have at looked the source code of the RSTRFCM1 report, which is called when deleting a queue from LBWQ.

This fragment of code deletes a queue. It needs two input parameters: the queue's name and the destination.

REPORT zbw_extractqueue_delete .

PARAMETER: qname LIKE trfcqout-qname DEFAULT 'MCEX??',
           dest LIKE trfcqout-dest DEFAULT 'NONE'.

DATA sl_entry(96).

CONCATENATE sy-uname '&' qname ','
            dest INTO sl_entry.
CALL 'C_WRITE_SYSLOG_ENTRY' ID 'TYP'  FIELD space
                            ID 'KEY'  FIELD 'Q22'
                            ID 'DATA' FIELD sl_entry.

CALL FUNCTION 'TRFC_QOUT_DELETE_QUEUE'
     EXPORTING
          qname = qname
          dest  = dest.

Cheers, Davide