MSsubscriber_info (distribution database only)

For SQL Server 6.5 information, see MSsubscriber_info Table in What's New for SQL Server 6.5.

Distribution database table. Contains information used by SQL Executive for passing jobs.

Column Datatype Description
publisher varchar(30) The name of the publisher.
subscriber varchar(30) The name of the subscriber.
type tinyint The subscriber type. 0 indicates SQL Server 6.0 subscriber. 1 indicates an ODBC data source.
login varchar(30) Allows NULL.
password varchar(30) Allows NULL.
commit_batch_size int The number of transactions executed on the subscriber before a commit is issued.
status_batch_size int The number of transactions before the status state is updated.
flush_frequency int The minimum time, in hours, that transactions will be retained within the distribution database after they have been distributed.
frequency_type int The primary frequency of this task. One time, On demand, Daily, and so on.
frequency_interval int The interval of frequency_type.
frequency_relative_interval int The relative interval for day of the month when the freqtype is monthly (32).
frequency_recurrence_factor int The recurrence factor based on the frequency_type.
frequency_subday int The reschedule occurrence based on frequency_interval. Once, every second, every minute, every hour.
frequency_subday_interval int The amount of time per frequency_subday when it is a unit of time.
active_start_time_of_day int The time of day when this task is active.
active_end_time_of_day int The time of day this task is no longer active.
active_start_date int The date and time after which this task may be scheduled.
active_end_date int The date and time after which this task may no longer be scheduled.
retryattempts int The number of retry attempts when a task execution fails.
retrydelay int The delay, in minutes, between retry attempts.

Index

ucMSsubscriber_info clustered, unique on publisher, subscriber