SQLTeam.com | Weblogs | Forums

Msg 14266, Level 16, State 1


Hi, I dropped transactional replication and trying to recreated it in lower environment. Scripted out publication script before dropping. I got below error.

Msg 14266, Level 16, State 1, Procedure sp_verify_schedule, Line 96
The specified '@freq_type' is invalid (valid values are: 1, 4, 8, 16, 32, 64, 128).

also created the subscription manually. but it did not start the snapshot automatically at end and received below error.Snapshot agent is missing

Could not find the regular snapshot job for the specified publication 'abcd'.
Supply either @job_id or @job_name to identify the job.
Changed database context to 'OLTP'. (Microsoft SQL Server, Error: 20678)

I tried below options but no luck. Please advise

Deleted the replication subscription and publication
ran sp_removedbreplication
disabled publishing for distributer and reconfigured the distributer
enabled the replication database
retried configuring replication but still snapshot agent is missing


Please look inside the code for @freq_type where you can find the offending line.
To know the basics of how to apply snapshot please go this one. https://msdn.microsoft.com/en-us/library/ms151788.aspx