SQLServerCentral.com / SQL Server 2008 - General / SQL Server 2008 / REG:JOB / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 19:02:30 GMT20RE: REG:JOBhttp://www.sqlservercentral.com/Forums/Topic1419315-391-1.aspxThanks . I got itWed, 13 Feb 2013 05:43:45 GMTm.rajesh.ukRE: REG:JOBhttp://www.sqlservercentral.com/Forums/Topic1419315-391-1.aspxSet the frequency on the schedule to Monthly on the X X of every 9 month(s)Wed, 13 Feb 2013 01:37:27 GMTanthony.greenREG:JOBhttp://www.sqlservercentral.com/Forums/Topic1419315-391-1.aspxHi, 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 .Wed, 13 Feb 2013 00:18:20 GMTm.rajesh.uk