---

USE [myNewVasya];
SET NOCOUNT ON;

-- 1. Публикация и точные имена двух статей.
SELECT
    p.name AS publication_name,
    p.immediate_sync,
    p.allow_anonymous,
    a.artid AS article_id,
    a.name AS article_name,
    OBJECT_SCHEMA_NAME(a.objid) AS source_schema,
    OBJECT_NAME(a.objid) AS source_table,
    a.dest_owner,
    a.dest_table
FROM dbo.syspublications AS p
JOIN dbo.sysarticles AS a
    ON a.pubid = p.pubid
WHERE p.name = N'V3Trans'
  AND a.objid IN
  (
      OBJECT_ID(N'dbo.sb_answer'),
      OBJECT_ID(N'dbo.sb_answerData')
  );

-- 2. Подписки именно этих статей.
SELECT
    p.name AS publication_name,
    a.name AS article_name,
    srv.name AS subscriber_name,
    s.dest_db AS subscriber_database,
    s.subscription_type,
    s.status
FROM dbo.syspublications AS p
JOIN dbo.sysarticles AS a
    ON a.pubid = p.pubid
JOIN dbo.syssubscriptions AS s
    ON s.artid = a.artid
LEFT JOIN sys.servers AS srv
    ON srv.server_id = s.srvid
WHERE p.name = N'V3Trans'
  AND a.objid IN
  (
      OBJECT_ID(N'dbo.sb_answer'),
      OBJECT_ID(N'dbo.sb_answerData')
  );

-- 3. Состояние нужного задания после предыдущих действий.
SELECT
    j.name,
    ja.start_execution_date,
    ja.stop_execution_date
FROM msdb.dbo.sysjobs AS j
LEFT JOIN msdb.dbo.sysjobactivity AS ja
    ON ja.job_id = j.job_id
   AND ja.session_id =
       (SELECT MAX(session_id) FROM msdb.dbo.syssessions)
WHERE j.name =
    N'WIN-5ODCFIGQRP3\SQL20-myNewVasya-V3Trans-WIN-5ODCFIGQRP3\SQL20-3';