sql server replication: It depends on what you're after. There is a status event that can be used
from the ActiveX controls, or the built-in replication alerts can be used
for monitoring of sorts.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Does anyone know how to monitor SQLServer replication through Delphi
environment? Using MSSQL.

Just need to show if the replication is happening or has it stopped.
Not sure which status event are you refering too...
thanks for all the information.

I use this procedure to determine if a job is executing:
http://www.replicationanswers.com/Downloads/KillRunningJobs.txt
The last part is used to kill the job, but you can leave this bit out :)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Thanks Paul, Command "master.dbo.xp_sqlagent_enum_jobs 1, 'dbo' "
exactly gives me the information that I need to check when was a job
last executed and when is it scheduled to be executed next.

One question, Looking at the JobIDs, how would one know which JobID
belongs to what? more specifically, which JobID belongs to replication.

Hi,
my procedure or sp_helpjob will both give you the info you require, but
you'll need to know the name of the job before running.
Alternatively you could iterate through all the jobs and return a dataset of
the jobnames and their status - depends on what you require.
Alternatively, by querying the jobstep details (sysjobsteps), you could no
doubt deduce which job is a replication job and do it this way, provided you
don't have too many.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Thanks Paul Ibison, cause of your help, I was able to solve the issue.
Thank you.

Just wanted to make sure that I come here and tell you that YOU are the
kind of people who give unconditionally. Thanks for giving me your
precious time and sharing your knowledge with everyone.
Cheers