Re: Getting snapshot job_id

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I don't have a syspublications table. I've looked in the database being
published, the master and msdb databases.


"Nitin" <Nitin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E0FB2C01-6166-4122-8A93-B10DC968527D@xxxxxxxxxxxxxxxx
> Select msdb.dbo.sysjobs.name from msdb.dbo.sysjobs INNER JOIN
> pubisherserver.publisherdb.dbo.syspublications
> ON (msdb.dbo.sysjobs.job_id =
> pubisherserver.publisherdb.dbo.syspublications.snapshot_jobid)
> WHERE pubisherserver.publisherdb.dbo.syspublications.name = 'Your
> publication Name'
>
> -Nitin Rana
>
>
> "Darren" wrote:
>
> > After creating a snapshot job using sp_addpublication_snapshot how do I
get
> > the job_id?
> >
> > I want to be able to rename the job as well as change the owner through
> > script after it is created but sp_update_job requires the old name or
job id
> > and sp_addpublication_snapshot doesn't return either.
> >
> > Thanks
> >
> >
> >
> >


.

Relevant Pages

  • Re: Getting snapshot job_id
    ... > I don't have a syspublications table. ... the master and msdb databases. ... >> publication Name' ...
    (microsoft.public.sqlserver.replication)
  • how to move master,model,msdb to another drive
    ... Can you tell me how to move the master, model, msdb databases to another ... My current drive is being decommission. ... Thanks a bunch. ...
    (microsoft.public.sqlserver.programming)