ejecuta job en servidor remoto

[iislas]

Cispus

Si hablamos de un SQL SERVER 2000, deberias optar por la opcion de TRANSVASE (LOGSHIPPING) que te proporciona el mismo motor.

Si solo es ejecutar el JOB de tu otro servidor, bueno, entonces, ejecutalo con DTSRUN.EXE

dtsrun
[/?] |
[
[
/[~]S server_name[\instance_name]
{ {/[~]U user_name [/[~]P password]} | /E }
]
{
{/[~]N package_name }
| {/[~]G package_guid_string}
| {/[~]V package_version_guid_string}
}
[/[~]M package_password]
[/[~]F filename]
[/[~]R repository_database_name]
[/A global_variable_name:typeid=value]
[/L log_file_name]
[/W NT_event_log_completion_status]
[/Z] [/!X] [/!D] [/!Y] [/!C]
]

Saludos