...
Step 2: Create a corresponding table in the DB
...
| Code Block | ||
|---|---|---|
| ||
CREATE TABLE ANALYTICS.BQMS_EXPLODED_SAMPLES
(
KEY VARCHAR2 (100),
SUMMARY VARCHAR2 (100),
STATUS VARCHAR2 (50),
REPORTER VARCHAR2 (60),
PRODUCT_AND_PROCESS VARCHAR2 (100),
SAMPLE_ID VARCHAR2 (50),
UPDATED DATE
)
/
CREATE INDEX ANALYTICS.BQMS_EXPLODED_SAMPLES_IDX1 ON BQMS_EXPLODED_SAMPLES(KEY ASC)
/
GRANT ALL ON BQMS_EXPLODED_SAMPLES TO analyticsetl
/
|
Step 3: Register a new JqlTask in “jqlTasks.conf” file
...