Maint. Plan

There is a Database Maintaince plan exist in my database but I want to check
what this database maintaince plan do? Can I know through any command or
query ?
YOu can watch the steps in the EM. Becasuse of not knowing if you have an
MSDE or not, i assume gtaht our are using an MSDE. In the msdb database
there are serveral tables for the jobs, you can qeyr them for further
information of the jobs,jobssteps and scheduling information:
Example:
SELECT dbo.sysjobs.name, dbo.sysjobs.enabled, dbo.sysjobs.description,
dbo.sysjobsteps.step_id, dbo.sysjobsteps.step_name,
dbo.sysjobsteps.command
FROM dbo.sysjobs INNER JOIN
dbo.sysjobsteps ON dbo.sysjobs.job_id =
dbo.sysjobsteps.job_id
Otherwise the recommondation od MS is not to touch the systemtables more
than necessary, so i mentioned also that there are serveral SPs in the MSDB
DB which are realted to the Jobs System:
sp_help_job
sp_help_jobstep
sp_help_jobserver
sp_help_jobschedule
sp_help_jobhistory
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:uNKvw9PRFHA.2604@.TK2MSFTNGP10.phx.gbl...
> There is a Database Maintaince plan exist in my database but I want to
> check
> what this database maintaince plan do? Can I know through any command or
> query ?
>
|||Thanks for your reply but can you explain me about this like how can I
understand from the following command.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
C8754E1A-484E-42D5-95B7-91427E7ADB9E -WriteHistory -RmUnusedSpace 1000 15 '
I think now you got my question what I wanna ask ...
thanks
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OeSGaPQRFHA.2252@.TK2MSFTNGP15.phx.gbl...
> YOu can watch the steps in the EM. Becasuse of not knowing if you have an
> MSDE or not, i assume gtaht our are using an MSDE. In the msdb database
> there are serveral tables for the jobs, you can qeyr them for further
> information of the jobs,jobssteps and scheduling information:
> Example:
> SELECT dbo.sysjobs.name, dbo.sysjobs.enabled, dbo.sysjobs.description,
> dbo.sysjobsteps.step_id, dbo.sysjobsteps.step_name,
> dbo.sysjobsteps.command
> FROM dbo.sysjobs INNER JOIN
> dbo.sysjobsteps ON dbo.sysjobs.job_id =
> dbo.sysjobsteps.job_id
> Otherwise the recommondation od MS is not to touch the systemtables more
> than necessary, so i mentioned also that there are serveral SPs in the
MSDB
> DB which are realted to the Jobs System:
> sp_help_job
> sp_help_jobstep
> sp_help_jobserver
> sp_help_jobschedule
> sp_help_jobhistory
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:uNKvw9PRFHA.2604@.TK2MSFTNGP10.phx.gbl...
>
|||Check out xp_sqlmaint in BooksOnLine for what the command and it's options
do. But you really need Enterprise manager to display the whole Maintenance
plan in an easily understandable format.
Andrew J. Kelly SQL MVP
"Joh" <joh@.mailcity.com> wrote in message
news:edrDm0QRFHA.2748@.TK2MSFTNGP09.phx.gbl...
> Thanks for your reply but can you explain me about this like how can I
> understand from the following command.
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> C8754E1A-484E-42D5-95B7-91427E7ADB9E -WriteHistory -RmUnusedSpace 1000 15
> '
> I think now you got my question what I wanna ask ...
> thanks
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:OeSGaPQRFHA.2252@.TK2MSFTNGP15.phx.gbl...
> MSDB
>