customqueryjob & enhancedqueryexecution job update formats

[Harish1]

Hi

Recently our saviynt version upgraded from 23.5 to 23.12, we're facing the problem with custom query jobs. 

In generally if any task is error out, we used to reopen and reprovision it. Below is the query we are using in custom query job. 

update arstasks set status=1 where taskkey=2322

Kindly suggest us the right format in enhancedqueryexecution job.

[Manu269]

@Harish1 why dont you try it via analytics.

You can get the report to fetch the error task and then configure default action

[rushikeshvartak]

Select taskkey as arstasks__taskkey , 1 as arstasks__status from arstasks where taskkey=999

[Harish1]

Thank you for your response, while creating the job using above query, we're facing the below error.

Select taskkey as arstasks__taskkey , 1 as arstasks__status from arstasks where taskkey=2322

Regards,

Harish

[rushikeshvartak · Accepted solution]

Select taskkey as arstasks__primarykey , 1 as arstasks__status from arstasks where taskkey=2322

[rushikeshvartak]

If above query worked accept solution and close the thread