SQL Server 2008 job failure
Condsiderations for linked server security options in SQL Server

(Two things to mention for typical simple configurations)




If you have the option set to Be made using the login's current security context then . . . 


ensure that the security principal (and context) that the job will RUN AS from the SQL Agentjob also has appropriate access to any of the linked server DB(s) which the job will need to access for it's queries, etc.
if the security principal is a local SQL login and not a domain or trusted domain account, then be sure that the local SQL account is created with a matching SID on both the linked server SQL Server instance and the SQL Server instance where the job is using the linked server from. 






If you have the option set to Be made using the security context: then . . . 


ensure the local SQL login security principal is created with a matching SID on both the linked server SQL Server instance and the SQL Server instance where the job is using the linked server from.