While performing a one way sync on a selected table, the job agent notices that there are 0 SrcRows, and 1 TgtRows, but does not delete the target rows.
In the 'Deleted' column of the output from Job Agent, it prints 'No change'.
I am not sure if there is an explicit option to remove target rows that don't appear in the source table (like the –delete flag with rsync), but the job isn't performing as expected.
Thanks!