• Hi Randy

    Yes there is a way to convert an MSX job to a local job. But remember, with great power comes great responsibility. ;-).

    In the msdb db on the target server in the sysjobs table, is a column - originating_server_id. For jobs that originate from a Master server, these are a 1. Update the 1 to a 0 and the job becomes local.