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

---

subu

Answer 1

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

Answer 2

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

Answer 3

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

---

subu

Answer 4

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

Answer 5

Hi Leks

Thanks for your reply.

But one thing i had executed manually. here it success..

once again i will execute it.

Tx

---

subu