CustomQueryJob in EIC version

[SanketBhandhari]

Hi All,

I want to use customqueryjob in EIC version of Saviynt but in my query I am getting error.

SELECT '<<AccountName>>' AS NAME FROM ACCOUNTS  where ACCOUNTKEY = <<AccountKey>>;

My requirement is to update account name of particular user using his accountkey.

Any help or pointer is much appreciated.

Regards,

Sanket Bhandhari

[SumathiSomala · Accepted solution]

@SanketBhandhari try below query

SELECT 'savtest99' AS ACCOUNTS__NAME ,ac.accountkey as ACCOUNTS__PRIMARYKEY FROM ACCOUNTS ac where ac.accountkey=4007;

Use Enhanced Query Execution Job