And one more question.
SQL Server job in step 1 is calling stored procedure that
accesses DB2 and SQL Server linked servers
and that job is running OK.
I checked SQL Server Agent Connection Tab Properties
in Enterprise Manager and it shows "SQL Server connection: Use Windows Authentication".
Then I went to Services console and checked SQLERVERAGENT
Properties / Log On tab. "Local System account" is checked.
I'm not quite sure what account Agent is running under but in any case it's not "niadetl" account.
So I'm confused now.
According to Steve Jones only the account specified
in Security Tab of Linked Server properties can access
linked server catalogs and in my case it's "naidetl" account.
Then how come SQL Server Agent successfully runs the job that
is accessing the linked server registered with "niadetl" account?