Dear Friends

Please suggest where i can get the status for the
replication ( Same is working or in failed status ). What
i want to do is when the user is taking the INVOICENUMBER
from the application it should check for the status of
the replication if the same is working or not.

Your guidance will enable me to solve the problem.

Thanks and best regards

Have a look at something like this that I use for a
related (non-replication) issue:

CREATE PROCEDURE spReturnJobState (@JobID
uniqueidentifier, @JobState int OUTPUT)
/*********************************************************
*******************************
Description: Script to return the job state of the
data load job so if it is running we can stop it.
Returns: (None)
Author: Paul Ibison (xt 26163)
Date Created: 22/12/2004
Revisions:
**********************************************************
*******************************/
AS

CREATE TABLE #xp_results (job_id UNIQUEIDENTIFIER NOT
NULL,
last_run_date INT
NOT NULL,
last_run_time INT
NOT NULL,
next_run_date INT
NOT NULL,
next_run_time INT
NOT NULL,
next_run_schedule_id INT
NOT NULL,
requested_to_run INT
NOT NULL, -- BOOL
request_source INT
NOT NULL,
request_source_id sysname
collate database_default null,
running INT
NOT NULL, -- BOOL
current_step INT
NOT NULL,
current_retry_attempt INT
NOT NULL,
job_state INT
NOT NULL)

INSERT INTO #xp_results
EXECUTE master.dbo.xp_sqlagent_enum_jobs 1, 'dbo'

SELECT @JobState = job_state FROM #xp_results WHERE
job_id = @JobID

DROP TABLE #xp_results


-- 1 = Executing, 2 = Waiting For Thread, 3 = Between
Retries, 4 = Idle, 5 = Suspended, 6 = [obsolete], 7 =
PerformingCompletionActions

Rgds,

Ah.... eureka! That explains why I keep seeing 23s in my
job history :)
Paul

[quoted text, click to view]