Re: how to remove scheduled backup tasks

From: Andrew J. Kelly (ajkellynospam@attbi.com)
Date: 04/21/03


From: "Andrew J. Kelly" <ajkellynospam@attbi.com>
Date: Mon, 21 Apr 2003 15:54:28 -0400


You need to refresh the screen in Enterprise manager for them to show up.
Either close and re-open EM or right click on the Jobs folder and choose
Refresh.

-- 
Andrew J. Kelly
SQL Server MVP
"Mabel" <mabct@hotmail.com> wrote in message
news:04b401c30839$b9864b50$2f01280a@phx.gbl...
> I just installed SQL 2000 Server on a new computer and am
> still learning how to administer a SQL db using the SQL
> Server Enterprise Manager. For testing purposes, I've
> created 2 backup jobs to backup the db at different times
> and days. (right-click the db name - All Tasks - Backup
> DB). I didn't use any scripts at all. However, when I
> decided to edit one of the jobs, I cannot find where the
> jobs are listed where I can make changes/ removal. Any
> help is appreciated. Thank you.


Relevant Pages

  • Re: SQL 2000 view current job status best practice
    ... Your asking for something that isn't doable in SQL Server ... solution to make the job status viewable from within SQL Enterprise Manager. ... jobs running on production SQL 2000 Servers. ...
    (microsoft.public.sqlserver.security)
  • Re: Run Multiple dts packages from a job.
    ... Simply go to the jobs section in Enterprise Manager ... If you want an easy way to generate the DTSRUN cmd then use ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • .Working with jobs when Agent is stopped.
    ... This could be done in SQL ... 2000 Enterprise manager but does not appear to be available in Management ... I don't want to start the Agent as this will run the jobs. ...
    (microsoft.public.sqlserver.tools)
  • Re: Access to Enterprise Manager without being an Admin
    ... Enterprise Manager is using sp_help_job to ... retrieve the information and if the user isn't a sysadmin, ... it will only retrieve the jobs that the user owns. ...
    (microsoft.public.sqlserver.security)
  • Setting SEED value for a existing column
    ... I need to set a new SEED value to an existing identity column through Query. ... DBCC CHECKIDENT (jobs, RESEED, 30) ... but Enterprise Manager still shows the old SEED value. ...
    (microsoft.public.sqlserver.replication)