sys.sp_dropdynamicsnapshot_job

Description

Removes a filtered data snapshot job for a publication with parameterized row filters. This stored procedure is executed at the Publisher on the publication database. When the job is deleted, all of the related data is deleted from the The name of the publication from which the filtered data snapshot job is being removed.

Syntax

sp_dropdynamicsnapshot_job
[ @publication = ]
N
'publication'
[ , [ @dynamic_snapshot_jobname = ]
N
'dynamic_snapshot_jobname'
]
[ , [ @dynamic_snapshot_jobid = ]
'dynamic_snapshot_jobid'
]
[ , [ @ignore_distributor = ] ignore_distributor ]
[ ; ]