Does anyone know of a way to execute a stored procedure that uses a remote login and the sp most be run as a scheduled job. When the scheduled job runs it uses the default login sa. We have setup a remote login id that we need to use instead. Any ideas? Thanks.