Finally was able to spend the time needed to figure this out.  There was a custom table that was added to the view the merge statement was pulling from.  That...

This is the code in the stored procedure

Merge into FINANCE_CURRENT_GROSS_PROFIT as tab1

using

(

SELECT

JCCo, [Contract], ContractAmt, ProjectedGP, AcctGP

FROM dbo.FINANCE_CURRENT_GP

) as tab2

on tab1.JCCo=tab2.JCCo and tab1.Contract=tab2.Contract

when matched then update set tab1.ContractAmt=tab2.ContractAmt,tab1.ProjectedGP=tab2.ProjectedGP,tab1.AcctGP=tab2.AcctGP

when not matched then

insert...

This is in one database and when run manually the stored procedure works correctly and populates three fields in the merge statement. When you run it through the job it...