--Deleted

For others, here is that image again:

Select from a CTE which contains ROW_NUMBER(), partitioned by AgentId and ordered by RecruitmentDate Desc, where ROW_NUMBER() = 1.

Does that file path exist on the server, or on your local machine?

Here's a quote from the online documentation (the emboldening is mine):

data_file must specify...

Thinking about this a little more, if you called the variable @ExecutionSuccess rather than @ExecutionStatus, the zero/one setting becomes slightly clearer.

If I quote from your original post:

This implies that you...