I am trying to use
sp_help_jobstep
to detail the scheduled tasks on my server.
However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?
Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?
I am using SQL 7 and got this SP from bol.
ThanksOriginally posted by FunkyD
I am trying to use
sp_help_jobstep
to detail the scheduled tasks on my server.
However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?
Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?
I am using SQL 7 and got this SP from bol.
Thanks
Fixed it - forgot that you have to run against MSDB...lol
Showing posts with label tasks. Show all posts
Showing posts with label tasks. Show all posts
Wednesday, March 21, 2012
Wednesday, March 7, 2012
list of common maintenance tasks?
I'm new to SQL Server after moving an online database from Access to SQL
Server. My database is about 170mb now, and I really don't have any idea
what I need to be doing on a regular basis to keep it 'well-oiled'. What
are the common maintenance tasks in order to keep it running as quickly and
as efficiently as possible?
Any help or pointers to help would be great appreciated.
Thanks,
GlennThe place to start is to open up SQL Enterprise Manager. Select your server
and then choose the Tools | Database Maintenance Planner option. Then
follow the instruction on the Wizard screens.
Mike O.
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>|||It will take a few hours, but please read the SQL Server 2000 Maintenance
and Operations Guide at
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>
Server. My database is about 170mb now, and I really don't have any idea
what I need to be doing on a regular basis to keep it 'well-oiled'. What
are the common maintenance tasks in order to keep it running as quickly and
as efficiently as possible?
Any help or pointers to help would be great appreciated.
Thanks,
GlennThe place to start is to open up SQL Enterprise Manager. Select your server
and then choose the Tools | Database Maintenance Planner option. Then
follow the instruction on the Wizard screens.
Mike O.
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>|||It will take a few hours, but please read the SQL Server 2000 Maintenance
and Operations Guide at
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>
list of common maintenance tasks?
I'm new to SQL Server after moving an online database from Access to SQL
Server. My database is about 170mb now, and I really don't have any idea
what I need to be doing on a regular basis to keep it 'well-oiled'. What
are the common maintenance tasks in order to keep it running as quickly and
as efficiently as possible?
Any help or pointers to help would be great appreciated.
Thanks,
GlennThe place to start is to open up SQL Enterprise Manager. Select your server
and then choose the Tools | Database Maintenance Planner option. Then
follow the instruction on the Wizard screens.
Mike O.
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
and
and Operations Guide at
http://www.microsoft.com/technet/tr...ide/default.asp
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
and
Server. My database is about 170mb now, and I really don't have any idea
what I need to be doing on a regular basis to keep it 'well-oiled'. What
are the common maintenance tasks in order to keep it running as quickly and
as efficiently as possible?
Any help or pointers to help would be great appreciated.
Thanks,
GlennThe place to start is to open up SQL Enterprise Manager. Select your server
and then choose the Tools | Database Maintenance Planner option. Then
follow the instruction on the Wizard screens.
Mike O.
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
quote:
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
quote:|||It will take a few hours, but please read the SQL Server 2000 Maintenance
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>
and Operations Guide at
http://www.microsoft.com/technet/tr...ide/default.asp
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
quote:
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
quote:
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>
Subscribe to:
Posts (Atom)