Post reply

REG:JOB

  • February 13, 2013 at 12:18 am

    #289274

    Hi,

    I want to run a script for every 9 months. Which deletes data in all tables in a database. I thought of creating a job for doing this task. How can i do that in sql 2008 r2 . I could not found any option for scheduling it for particular time .

  • February 13, 2013 at 1:37 am

    #1587312

    Set the frequency on the schedule to Monthly on the X X of every 9 month(s)

  • February 13, 2013 at 5:43 am

    #1587394

    Thanks . I got it

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply