A man has managed to escape uninjured after he was targeted in a drive-by shooting in Sydney.