Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Data in 'subsystem' column of the SYSJOBSTEPS table (SQL2000)

0 views
Skip to first unread message

Jagannathan Santhanam

unread,
Mar 21, 2002, 5:31:38 PM3/21/02
to
Hello
As you all are aware, the SYSJOBSTEPS (system) table in SQL Server
2000 contains the individual steps of a particular job. When you
define the step using Enterprise manager, you select this "type" from
a drop-down list. My question is, is this a constant list that never
changes OR can you change an existing value in this list ?

Reason I am asking this is because, if you do a simple SELECT from the
SYSJOBSTEPS table (on a replicating Server which is both the publisher
and the distributor), you will see a column called "subsystem" which
will have a value of "LogReader" or "Distribution" for the replication
logreader and distribution tasks respectively. Can I assume that the
"subsystem" column value will always be "logreader" or "distribution"
for the replication logreader and distribution tasks respectively ?

Thanks in advance

Jagannathan Santhanam

0 new messages