Post reply

Status of maintenence job

  • July 16, 2014 at 5:36 am

    #397066

    Hello experts,

    I am new to MS SQL Server 2008 so please be gentle on me.

    I have created a maintenance job, the maintenance job consists of a 'Execute TSQL statements' task. I have just one SQL statement inside this task it is,

    USE [LIVEDB]

    GO

    ALTER INDEX [Fact_SellID] ON [dbo].[sell_fact] REORGANIZE WITH ( LOB_COMPACTION = ON )

    I have scheduled this job to run 5 mins back and i think it is running at the moment, however when i right click the maintenance job and click on 'view history' i simply see a line with a 'notepad' icon with no date and no status and not much details. How do i find out the current status of this job? and how much % the job has completed? Any thoughts?

    Thanks

  • July 16, 2014 at 5:52 am

    #1729804

    Go to SQL Server Agent and open Jobs. There should be a job called something like <Name-of-your-maintenance-plan>.Subplan_1. You'll be able to see whether that's still running or finished.

    John

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

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