Enhanced query execution job

[Lynn]

Hi

I am trying to create a enhanced query execution job, but I could not find the parameters for it in document.

I tried the CustomQueryJob but it did not help.

Any suggestion?

Regards,

Lynn

[This message has been edited to move comment to its own post]

[rushikeshvartak]

You can check browser network logs to check what parameters are required during UI job creation 

[Lynn]

Hi Rushikesh,

I checked the network log and use the same parameters: the trigger is created, but the parameters are not set:

{
"triggers": [{
"valueMap": {

"queryText": "Select a.accountkey as accounts__primarykey, a.status as accounts__CUSTOMPROPERTY18 from accounts a where a.endpointkey = (select endpointkey from endpoints where endpointname = 'EP_test')",
"queryDescription": "test",
"queryType": "Update"
},

"triggername": "query_execution_1",
"group": "GRAILS_JOBS",
"triggergroup": "GRAILS_JOBS",
"jobname": "CustomQueryV2Job",
"jobgroup": "utility",
"cronexpression": "0 33 14 * * ? 2099"
}
]
}

Regards,

Lynn

[rushikeshvartak]

I am also trying different option also provided feedback on documentation for proper variable. will keep you posted

[avinashchhetri]

Lynn,

Enhanced query is not currently supported via API's.

[rushikeshvartak]

Created new idea ticket https://ideas.saviynt.com/ideas/EIC-I-5989 

[rushikeshvartak]

have created using api and it works as expected 

[
{
"triggers":[

{
"valueMap":{
"CONNECTION":"Saviynt",
"connectiontype":"DB",
"connectionid":6
},
"name": "rushiapi1",
"group": "GRAILS_JOBS",
"jobName": "AccountsImportFullJob",
"jobGroup": "DATABASE",
"cronExp": "0 33 14 * * ? 2060"
}
]
}
]