Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

CUSTOMQUERYJOB - is failing

suresh99
New Contributor
New Contributor

Hi Team,

We want to mask some set of emails , so we need to update Users table , the  query worked week before but its not working now.

update users set email=concat(email,’_dev’) where city='Singapore'

Is that Job depricated aleady , any idea ?

Can you let us know how to mask bulk emails

 

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

Does it satisfies to any user ? Please run select query from data analyzer

select email from users where city='Singapore' and email not like '%dev';

if above query returns result then what is error in log ? 
what is frequency of job ?

try adding semi colon in end 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Yes we have results coming in Data Analyser. There is no error in the logs but query is printing.

Its adhoc job we are running on demand, tried with semi colon as well.

rushikeshvartak
All-Star
All-Star

Try Below query (Your query has wrong single quote near _dev

update users set email = concat(email, ' _dev ') where city = 'Singapore'


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

suresh99
New Contributor
New Contributor

Thanks it worked.