Status Property (Subscription Objects)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The Status property returns component execution or integrity state information.
The subscription is active. The agent maintains the subscription.
The subscription is inactive. The agent does not maintain subscription.
The subscription state cannot be determined.
The subscription has not been synchronized. Manual or automated synchronization must occur before the agent can maintain the subscription.