June 14, 2013 at 11:31 am
Is there a way to find out (perhaps using DMVs) through TSQL if Replication failed between a given time frame? Thanks.
June 15, 2013 at 9:57 am
You can query the table dbo.msdistribution_history in the distribution database.
Have a look here: http://msdn.microsoft.com/en-us/library/ms179878.aspx
June 15, 2013 at 9:58 am
Additionally, have a look at the system tables dbo.sysjobs and dbo.sysjobhistory in the msdb database. Query for your replication jobs.
June 16, 2013 at 2:06 pm
WolfgangE (6/15/2013)
Additionally, have a look at the system tables dbo.sysjobs and dbo.sysjobhistory in the msdb database. Query for your replication jobs.
Thank You for this info-just one more curiosity- now Would I query this (msdb) in the publisher or the subscriber database ?
June 16, 2013 at 11:54 pm
msdb is a database itself, it's one of the system databases.
There your have the tables dbo.sysjobs, db.sysjobsteps and dbo.sysjobhistory for getting information about jobs that run.
June 17, 2013 at 10:39 am
WolfgangE (6/16/2013)
msdb is a database itself, it's one of the system databases.There your have the tables dbo.sysjobs, db.sysjobsteps and dbo.sysjobhistory for getting information about jobs that run.
oops by bad- what i meant was if publisher, distributor and subscriber reside in different servers (or instances for that matter)? Which msdb database would i be interested in?
June 17, 2013 at 11:51 am
All the jobs are running at the distributor.
First, have a look at the SQL-Jobs at the distributor via the "job activity monitor". There, in one of the columns, you can see the job category. You quickly will find out which jobs belong to your replication(s).
After that you know better what you should look for in the system tables.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply