Thanks Jon,

Turns out the source tables are part of an application and that application was updated over the weekend. So it's possible some indexes were outdated (?) by the time...

Thanks for following up,

1. sa is the job owner

2. the linked server is a Unix box, and I don't know how authentication has been set up for it. There are no...

No worries, I appreciate the help.

I don't know the answer to that question, tho. Is there a way to determine from the server if it is a master or a...

"I searched msdb..sysjobs on that machine, but could find no entries with that ID."

Looks like the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS maintains a list of SQL Servers previously accessed.