Can't access a linked server from a job
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
I have two databases on the same server db1 and db2.
I am using a link to insert data from db1 into a table in db2. This is being done from a stored procedure called PROC_DS_TEST_INSERT.
The syntax for the insert in this procedure is:
Insert into DS_TESTDRIVES
Select * from DRIVES@DB1 where drive_date >= to_Date('2023-01-01','YYYY-MM-DD') and rownum <200;
The account (BECS_ANALYTICS) that I am running this under in DB2 has read permissions on DB1 and this ran correctly when I executed the stored procedure by hand, but when I ran a job that executed that procedure, it did not run, and I received an error message.