Post reply

kill optimization maintenance plan process

  • May 19, 2008 at 11:09 am

    #121652

    I have a maintenance plan for optimization job for one database in sql server 2000. Now It was running since two days...So I stop that job...now I still have process from that plan and which is still running...Can I kill that process...Will it be ok???

  • May 19, 2008 at 11:13 am

    #817331

    You can kill the process, thats the right thing to do, that too will show status Killed\Rolled back for sometime.

    In my experience it's still better to kill job and you can get out of mess in better time.

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • May 19, 2008 at 11:15 am

    #817334

    This is the command that process does

    dbcc dbreindex(N'[dbo].[table_name]', N'', 90, sorted_data_reorg)

    Can I kill that?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply