QUEUE_SERVER

Arguments:

Source

Legend: comment string keyword reserved word operator

     1: PROCEDURE
     2: queue_server(server_id_in IN NUMBER, immediate_in IN NUMBER := 1)
     3: IS
     4:     org_id_tmp NUMBER;
     5: BEGIN
     6:     IF immediate_in > 0
     7:     THEN
     8:           rhn_server.update_needed_cache(server_id_in);
     9:     ELSE
    10:           SELECT org_id INTO org_id_tmp FROM rhnServer WHERE id = server_id_in;
    11: 
    12: 	  INSERT
    13:             INTO rhnTaskQueue
    14:                  (org_id, task_name, task_data)
    15:           SELECT org_id_tmp,
    16:                  'update_server_errata_cache',
    17:                  server_id_in
    18:           FROM DUAL
    19:           WHERE NOT EXISTS
    20:             (SELECT 1 FROM rhnTaskQueue
    21:                WHERE org_id = org_id_tmp
    22:                AND task_name = 'update_server_errata_cache'
    23:                AND task_data = server_id_in
    24:             );
    25:     END IF;
    26: END queue_server;