Re: Viewing properties of scheduled backup job

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/21/04 

Date: Fri, 20 Feb 2004 23:08:50 -0500

I think your looking under the Maintenance Plans node. You need to look
under the scheduled jobs node. They are two different things. 

-- 
Andrew J. Kelly
SQL Server MVP
"PD" <anonymous@discussions.microsoft.com> wrote in message
news:1448a01c3f81b$8fe4d550$a601280a@phx.gbl...
> The new maintenance jobs i've scheduled are listed under
> there, but none of the existing jobs are.
>
> If i right click a database, schedule a backup, it does
> not appear under here. It only seems to include jobs
> created under the maintenence wizard in here.
>
>
>
> >-----Original Message-----
> >There is a node in EM under the Maintenance folder that
> list the scheduled
> >jobs.  You will find it there.
> >
> >
> >-- 
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"PD" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:A2430F20-0A93-492B-ABA4-
> FB9BCAD281DA@microsoft.com...
> >> Our previous DB admin has configured nightly full
> backups of our database
> >individually using right click-->all tasks-->Backup
> database and then
> >setting schedule options.
> >>
> >> It works and the databases are backed up each night,
> overwriting the
> >previous one. He's since gone and i've set up a new
> maintainance schedule
> >instead using the maintainance wizard to back up all the
> databases nightly
> >and two weekly and also to perform optimisations and
> integrity checks as
> >well. Thing is, i cant see how to remove his existing
> nightly backups - they
> >dont show up anywhere, all the stuff im setting up now
> is visible under
> >'maintenance plans', but his jobs dont appear anywhere
> within Enterprise
> >manager - where do jobs go when they are set up as he
> did.
> >>
> >> I tried it myself, right click a DB, schedule a
> backup, and then try to
> >find any record this job exists - there isnt one that i
> can see anywhere. It
> >runs ok though.
> >
> >
> >.
> >

Relevant Pages

  • Re: Viewing properties of scheduled backup job
    ... The new maintenance jobs i've scheduled are listed under ... If i right click a database, schedule a backup, it does ...
    (microsoft.public.sqlserver.tools)
  • Re: Maintenace Interval/Online defragmentation- Best Practices
    ... >so I can determine what would be the best schedule for us. ... >doing all the maintenance at this time. ... and that the backup starts at 9PM. ... have enough time to complete a full sweep of the whole database. ...
    (microsoft.public.exchange.admin)
  • Re: time scheduling in ptyhon
    ... > I need schedule some jobs, times of this jobs are read from database. ... > So i would like to periodicallyrun some python script ...
    (comp.lang.python)
  • time scheduling in ptyhon
    ... I need schedule some jobs, times of this jobs are read from database. ... So i would like to periodicallyrun some python script(or ...
    (comp.lang.python)
  • Re: Combining templates
    ... Elevators to be exact. ... schedule our jobs based on the General contractors schedule. ... and template type (meaning what type of elevator are we installing). ...
    (microsoft.public.project)