No this is a new setup .

below is the query , whic is running fine while executing in mgmt studio

but i have put it in JOB , to perform it periodically

so when the job runs , it gives that error

-------------------------------------------------------

declare @SQLCmd varchar(100)

SET @SQLCmd = 'insert into ghi_prod.dbo.account_test SELECT TOP 1 * from mydba.ghi_prod.dbo.account '

EXEC(@SQLCmd) AT [mytesttest\DEV] <------linked server