CUSTOMQUERYJOB - is failing

[suresh99]

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

[rushikeshvartak]

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 

[suresh99]

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 · Accepted solution]

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

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

[suresh99]

Thanks it worked.