sql server replication:
Have any of you folks encountered error 14294 - "Supply
either @job_id or @job_name to identify job" while trying
to create a publication using the wizard?
I've tried deleting and recreating the subscription
database on the subscriber - no luck. When I run
sp_addpublication in query analyzer it fails on the same
error. The online books list "@logreader_job_name"
and "@qreader_job_name" as part of the stored procedure,
but I don't see either in the trace! Both are listed
as "For internal use only". Is it possible that I've
missed a step in creating the publication? There doesn't
seem to be a whole lot of references to this error on the
WWW.....
Thanks,
Bob
The profiler gives the following trace:
exec sp_addpublication
@publication = N'RCS_Whse_Repl',
@restricted = N'false',
@sync_method = N'native',
@repl_freq = N'continuous',
@description = N'Transactional publication of RCS_Whse
database from Publisher DOLPHIN.',
@status = N'inactive',
@allow_push = N'true',
@allow_pull = N'true',
@allow_anonymous = N'false',
@enabled_for_internet = N'false',
@independent_agent = N'false',
@immediate_sync = N'false',
@allow_sync_tran = N'false',
@autogen_sync_procs = N'true',
@retention = 336,
@allow_queued_tran = N'false',
@snapshot_in_defaultfolder = N'true',
@compress_snapshot = N'false',
@ftp_port = 21,
@allow_dts = N'false',
@allow_subscription_copy = N'false',
@add_to_active_directory = N'false'
exec sp_addpublication_snapshot
@publication = N'RCS_Whse_Repl',
@frequency_type = 4,
@frequency_interval = 1,
@frequency_relative_interval = 0,
@frequency_recurrence_factor = 1,
@frequency_subday = 1,
@frequency_subday_interval = 0,
@active_start_date = 0,
@active_end_date = 20031028,
@active_start_time_of_day = 221900,