locked
Schedule Annual Jobs RRS feed

  • Question

  • Hi,

    Initially, the start date was configured as 09-01-2008 however we seems to be getting it this current month (Oct 2014). That's why I had changed it to 09-01-2015 which is a future date. My concern is that, would this resolved the current issue and the job execute on 09-01-2015 at 9am?

    Regards,
    Qingyan

    Tuesday, October 7, 2014 2:56 AM

All replies

  • Can you elaborate? where did you change this? Some screenshots may help.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Tuesday, October 7, 2014 4:40 AM
  • Hi Visakh,

    I am unable to attached the screenshot as I just create an account. The jobs was configured to sent email to the intended user but was suppose to be sent annually on 4 - 10 Jan (multiple jobs). However, currently they have been receiving the email which is puzzling.

    I have provide the field for the SQL Server Agent Jobs which was filled up as below:

    Name: Reminder 6 - 9 Jan 09:00 AM
    Schedule Type: Recurring ("Enabled" checkbox was checked)
    Frequency: Monthyl (Occurs), Day 9 of every 12 month(s)
    Daily frequency: 09:00:00 (occurs once at)
    Duration: 09-01-2015 (Start Date) with no end date

    Sorry about that.

    I have uploaded the screenshot and you can download it from the link provided below:
    https://app.box.com/s/6g2qguvskcbvvfefn5fq

    • Edited by GreenLim Thursday, October 9, 2014 1:08 AM update information
    Thursday, October 9, 2014 1:05 AM