locked
Job Was scheduled every 3 months RRS feed

  • 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
    Monday, 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 AM
    Answerer
  • 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
    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
    Monday, February 1, 2010 3:13 AM
    Answerer

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 AM
    Answerer
  • 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
    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


    subu
    Monday, 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
    Monday, February 1, 2010 3:13 AM
    Answerer
  • Hi Leks

    Thanks for your reply.

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

    once again i will execute it.

    Tx
    subu
    Monday, February 1, 2010 3:16 AM