Does your job use xp_sendmail? Is the table a permanent one or a temp table? When referencing the table, try using the 3-part table name ('dbname.dboname.tablename' if static table) or a global temp table name ('tempdb.dboname.##globaltemptablename').

http://www.developmentnow.com/g/113_2004_11_0_0_436170/ODBC-error-208-42S02-Invalid-object-name.htm