Actually, Transactional Replication is running between Sql server 2005 to SQL Server 2000.
But, Replication Status is running fine. all agents are running fine. but the subscriber end , tables are not updating.
when I checked, through Replication Monitor, I find a message..
'The initial snapshot for publication xxxx is not yet available'.
So I reinitialized and fix the problem.
But, I want a way to be informed , when such kind of msg, or obsolete snapshot msg is showing .
So I want to create a job to monitor those activity and in the above case the job use to send a mail to me.
Do any body have better solution to overcome this issue.????
Thanks in Advance.