Harish Mohanbabu

Hi,
How to create jobs in MS SQL Server 2000 for the following purposes -
1. For re-organise/re-index to 10% per page &
2. For checking DB integrity.
Can someone let me know please.
TIA,
Harish
*********************************
Long way to go before I sleep ..
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Go to Enterprise Manager/management/database mainenance
plans. You can right click and select "new maintenance
plan", you just select the databases you want to setup and
it will walk you through the rest. You can also setup
full/tran log backups. You will then see the additions of
new jobs.
Hope that helps
thanks
Susan
>--Original Message--
>Hi,
>How to create jobs in MS SQL Server 2000 for the
following purposes -
>1. For re-organise/re-index to 10% per page &
>2. For checking DB integrity.
>Can someone let me know please.
>TIA,
>Harish
>
>*********************************
>Long way to go before I sleep ..
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>|||Hello Harish,
If you want the quick and dirty way use the maintenance wizard for this. If
you want scripts for this I can email some that I use.
Let me know if need to know how to run the maintenance wizard. Or just look
it up in the books online for SQL server, this is an excellent resource with
walk throughs and examples.
John...
"Harish Mohanbabu" <Harish@.nospam.com> wrote in message
news:eZ6VCrU$DHA.1732@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How to create jobs in MS SQL Server 2000 for the following purposes -
> 1. For re-organise/re-index to 10% per page &
> 2. For checking DB integrity.
> Can someone let me know please.
> TIA,
> Harish
>
> *********************************
> Long way to go before I sleep ..
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!