Re: MS SQL Backup Schedule

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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 10:02:44 +0200

Enterprise Manager, Management, SQL Server Agent, Jobs. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gerrym" <Gerrym@discussions.microsoft.com> wrote in message
news:7DC355DB-A511-4B91-A46D-17B309D4879C@microsoft.com...
> Thank you Tibor,  where can I see the scheduled jobs ?
>
> gerrym
>
> "Tibor Karaszi" wrote:
>
> > That dialog only creates an SQL Server agent job. Check in SQL Server Agent, Jobs and you will
see
> > you job(s) there.
> >
> > -- 
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Gerrym" <Gerrym@discussions.microsoft.com> wrote in message
> > news:CC53F517-4247-4CA8-9477-2225742E3494@microsoft.com...
> > > When I try to schedule a COMPLETE backup to Disk, I select the overwrite box
> > > and schedule. Then I select DAILY and a Time, click apply, and then OK.  When
> > > I go back in to review the setting it is back the way it was with no
> > > schedule.
> > > What am I doing wrong ?
> >
> >
> >

Relevant Pages

  • Re: Scheduled exec
    ... DB tasks can be done in SQL Server via Jobs. ... Windows Task Scheduler can run executables on a schedule. ...
    (microsoft.public.dotnet.general)
  • Re: stored procedures? timer
    ... Then I suggest you schedule the job once and have a loop in a TSQL jopstep with WAITFOR DELAY in the ... Tibor Karaszi, SQL Server MVP ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Move SQL Server to new hardware
    ... The machine name for your SQL Server agent jobs. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: stored procedures? timer
    ... If you want to use c#, connect to SQL server using ADO.NET and use ExecuteNonQuery ... to execute the sp_start_job procedure. ... Tibor Karaszi, SQL Server MVP ... >> Another option is to schedule an Agent job more frequently than minutes, ...
    (microsoft.public.sqlserver.server)
  • Re: Backup job for schema only
    ... You can use DMO to write a small all to extract the schema and schedule that app. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)