Answered by:
Job Was scheduled every 3 months

Question
-
Hi Team,
My clinet was send request for every 3 months schedule the job
but i'm checking this scheduling but it will showing perday,permonth
how can scheduled a job for every 3 months 1st sunday can you please guide me
Tx
subuMonday, February 1, 2010 2:14 AM
Answers
-
Go to new schedule --> select monthly for OCCURS option , then select the (FIRST) and (SUNDAY) for every 3 months and select the time from the daily frequency option.
Once successfully implemented - You will see the schedule column as -- Occurs every first Sunday of every 3 month(s) at 12:00:00 a.m.. Schedule will be used starting on 1/02/2010.
Is this fine ?
Thanks, Leks- Proposed as answer by Chirag Shah Monday, February 1, 2010 2:24 AM
- Marked as answer by Alex Feng (SQL) Tuesday, February 9, 2010 2:18 AM
Monday, February 1, 2010 2:23 AMAnswerer -
As said by Lekks
1. Eneter Name, create new schedule -- Select recurring radio button
2. Click on Change Frequency
Occurs: Monthly
On the Monthly : Select a First and day (Sunday) and change to three month by using up down numeric key pad
3. Click on OK- Marked as answer by Alex Feng (SQL) Tuesday, February 9, 2010 2:18 AM
Monday, February 1, 2010 2:25 AM -
I would like to see you opening new thread for different questions and that would be helpfule for someone else in future for solving their problem.
Open the maint plan package and look for error message from there.
Right click the package that failed and click view history and post the error.
Thanks, Leks- Marked as answer by Alex Feng (SQL) Tuesday, February 9, 2010 2:18 AM
Monday, February 1, 2010 3:13 AMAnswerer
All replies
-
Go to new schedule --> select monthly for OCCURS option , then select the (FIRST) and (SUNDAY) for every 3 months and select the time from the daily frequency option.
Once successfully implemented - You will see the schedule column as -- Occurs every first Sunday of every 3 month(s) at 12:00:00 a.m.. Schedule will be used starting on 1/02/2010.
Is this fine ?
Thanks, Leks- Proposed as answer by Chirag Shah Monday, February 1, 2010 2:24 AM
- Marked as answer by Alex Feng (SQL) Tuesday, February 9, 2010 2:18 AM
Monday, February 1, 2010 2:23 AMAnswerer -
As said by Lekks
1. Eneter Name, create new schedule -- Select recurring radio button
2. Click on Change Frequency
Occurs: Monthly
On the Monthly : Select a First and day (Sunday) and change to three month by using up down numeric key pad
3. Click on OK- Marked as answer by Alex Feng (SQL) Tuesday, February 9, 2010 2:18 AM
Monday, February 1, 2010 2:25 AM -
Hi Team,
Thank you for your reply..
But my job was failed can you please guide me how can i work on it.
this is weakly maintaince job re-bulid indexes,update statics
Started: 7:00:01 AM Progress: 2010-01-30 07:00:04.14 Source: {CB64FDAB-7C4B-429B-8022-09EE4A1ED7BC} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2010-01-30 07:00:04.49 Source: Check Database Integrity Task Executing query "USE [xxxdb] ".: 50% complete End Progress Progress: 2010-01-30 07:00:35.91 Source: Check Database Integrity Task Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2010-01-30 07:00:35.91 Source: Check Database Integrity Task Executing query "USE [xxxdb] ".: 50% complete End Progress Progress: 2010-01-30 07:00:41.36 Source: Check Database Integrity Task Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 201... The package execution fa... The step failed.
Tx
subuMonday, February 1, 2010 3:06 AM -
I would like to see you opening new thread for different questions and that would be helpfule for someone else in future for solving their problem.
Open the maint plan package and look for error message from there.
Right click the package that failed and click view history and post the error.
Thanks, Leks- Marked as answer by Alex Feng (SQL) Tuesday, February 9, 2010 2:18 AM
Monday, February 1, 2010 3:13 AMAnswerer -
Hi Leks
Thanks for your reply.
But one thing i had executed manually. here it success..
once again i will execute it.
Tx
subuMonday, February 1, 2010 3:16 AM