Instructs Replication Server to skip a failed replication definition request the next time Replication Agent starts. Use sysadmin skip_bad_repserver_cmd with the replication definition change request change process. See “Replication definition change request process,” in Chapter 9, “Managing Replicated Tables” in the Replication Server Administration Guide Volume 1 before you use sysadmin skip_bad_repserver_cmd.
WARNING! Use sysadmin skip_bad_repserver_cmd carefully. If you execute the command, and then restart the Replication Agent without executing the corrected replication definition command in the primary Replication Server, primary data may replicate using the wrong replication definition version.
sysadmin skip_bad_repserver_cmd, pds_name, pdb_name
The primary data server name.
The primary database name.
In this example, sysadmin skip_bad_repserver_cmd instructs Replication Server and Replication Agent to skip the last failed replication definition command in the pubs2 database of the SYDNEY_DS data server:
sysadmin skip_bad_repserver_cmd, SYDNEY_DS, pubs2
pds_name and pdb_name identify the specific Replication Agent that is affected by the failed replication definition request.
Use sysadmin skip_bad_repserver_cmdto instruct Replication Server to skip a failed replication definition request sent by a Replication Agent. When a replication definition command fails at the primary Replication Server, Replication Agent shuts down. If you restart Replication Agent, the failed command executes again unless Replication Server skips the command. After you execute sysadmin skip_bad_repserver_cmd, execute the corrected replication definition request at the Replication Server before starting the Replication Agent.
sysadmin skip_bad_repserver_cmd requires “sa” permission.
admin verify_repserver_cmd, rs_send_repserver_cmd, alter replication definition, alter applied function replication definition, alter request function replication definition, create replication definition, create applied function replication definition, create request function replication definition, drop replication definition