Can you run the job by using the Service Account that is running the SQL Agent?

I receive emails every time a 500 error occurs on the web server and yesterday I...

AccountName    Level    IsCurrent      Parent

District 1        1             0         ...

Hi,
Looks like you are working with slowly changing dimensions.  An alternate way is to split the MERGE statement into two, INSERT and UPDATE separately.

--Use Merge...

Hi,

ROW_NUMER()  analytical function can be used to generate a new number for each row.

Select t.*, ROW_NUMBER () over (order by sortid)   RowNumber
from #tblTasks...

Hi,
Reduce the Degree of parallelism setting to 2 and give it a try.