Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Why reorganize index maintainance plan is not executing? Expand / Collapse
Author
Message
Posted Monday, September 21, 2009 9:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 12:53 AM
Points: 4, Visits: 125
I have created a job in sql server 2005 i.e. for reorganize index maintainance plan on sunday. But it is not executing. Why?
Post #791201
Posted Monday, September 21, 2009 9:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:25 AM
Points: 201, Visits: 390
Did you verify that maintenance plan job still in place?
Did your check this job history?
Has this job ever started?
Post #791209
Posted Monday, September 21, 2009 9:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 12:53 AM
Points: 4, Visits: 125
I have checked all that u have mentioned above. This is weekly job.
Post #791220
Posted Monday, September 21, 2009 9:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:25 AM
Points: 201, Visits: 390
Does this job have any history?
What does it say?
Post #791226
Posted Monday, September 21, 2009 9:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 12:53 AM
Points: 4, Visits: 125
it is saying it is not executed
Post #791232
Posted Monday, September 21, 2009 9:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:25 AM
Points: 201, Visits: 390
Could you publish this job notification message here?
Post #791235
Posted Monday, September 21, 2009 9:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:25 AM
Points: 201, Visits: 390
Please make sure your job is not disabled.
Please open Properties->Schedule of your job and also make sure the job Schedule is enabled.
Post #791237
Posted Monday, September 21, 2009 9:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 12:53 AM
Points: 4, Visits: 125
Yes Its enabled.
Post #791248
Posted Monday, September 21, 2009 9:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:25 AM
Points: 201, Visits: 390
Yes Its enabled.
I assume it is about job and a shedule as well, right?

Again, could you publish the job notification message from the job history here?
Post #791255
Posted Tuesday, September 22, 2009 3:14 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487
The most possible reasons are already stated, May be the job itself or the schedule is disabled.

Can you try pointing the job and schedule again from Maintenance plan?


-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help
Post #791597
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse