Announcement

Collapse
No announcement yet.

Scheduled Batch Job Parameters

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Scheduled Batch Job Parameters

    How do I pass parameters to a batch job query?

    I have this query:

    SELECT
    COUNT(SQLMGR.HISTORY.F5) AS ClaimVolume,
    SUM(SQLMGR.HISTORY.UM002 + SQLMGR.HISTORY.UM003 + SQLMGR.HISTORY.UM004 + SQLMGR.HISTORY.ADMINFEE - SQLMGR.HISTORY.UM005) AS TotalSpend
    FROM
    SQLMGR.GROUPS
    INNER JOIN SQLMGR.HISTORY ON SQLMGR.HISTORY.GROUPNUM = SQLMGR.GROUPS.GROUPNUM
    INNER JOIN SQLMGR.PHARMACIES ON SQLMGR.HISTORY.F2 = SQLMGR.PHARMACIES.NABP
    INNER JOIN SQLMGR.MASTERDRUG ON SQLMGR.HISTORY.F4 = SQLMGR.MASTERDRUG.ABCUPCHRI
    INNER JOIN SQLMGR.CARRIER ON SQLMGR.GROUPS.CARRIERCODE = SQLMGR.CARRIER.CARRIERCODE
    WHERE
    SQLMGR.MASTERRX.ABC NOT IN ('99999999999933', '99999999999935', '99999999999999', '99999999999968', '88888888888821')
    AND SQLMGR.HISTORY.CYCLEDATE >= to_date([$ Start-mm/dd/yyyy],'mm/dd/yyyy')
    AND SQLMGR.HISTORY.CYCLEDATE <= to_date([$ End-mm/dd/yyyy],'mm/dd/yyyy')
    AND SQLMGR.CARRIER.CARRIERCODE = 'ABC02'
    GROUP BY
    SQLMGR.GROUPS.REPORTING2
    ORDER BY
    ClaimVolume DESC


    I want to pass the $Start and $End date parameters in the scheduled batch job as shown in this image:


    Click image for larger version

Name:	NavicatBatchJob.PNG
Views:	2
Size:	12.4 KB
ID:	2437


    When running the batch job I get this error: [Msg] [Exp] ORA-00936: missing expression.

    How can I resolve this error?
    Thank you.
    Attached Files

  • #2
    We are sorry that Navicat does not support your mentioned feature. Your request has been forwarded to our development team. We will keep improving our Navicat in the future. Thank you for your advice.

    Comment


    • #3
      Is this feature still beeing discussed? I was looking for something similar.

      Comment


      • #4
        It is already in our development list. However, we are unable to provide the time frame at this moment.

        Comment

        Working...
        X