Last post Apr 24, 2012 03:07 AM by Ashutosh Pathak
Apr 24, 2012 02:14 AM|demoninside9|LINK
In my database there is a table having two filelds first is Name and another is Levae_Available. Now what my requirement is that on Dec, 31 at 12:00AM if there are leaves available more than 10 then this table shluld be update on the same time.
So what should I need to use here webservices or sql jobs. Which is standard way to do that altough I am very new to both.
So could you please suggest and give some examples.
Apr 24, 2012 03:07 AM|Ashutosh Pathak|LINK
you just need to create a sql batch or stored procedure that will contain the update statement of your requirement, now you should create a SQL job, paste your query/stored procedure there in sql job steps. At the end you should schedule your sql job to
your required time which is 31st of Dec 31 at 12.00 AM. your query will only run on that time and will do the required things, if you want you can change the time schedule to run on some interval.
you should not choose web service, because you need to create again a UI or windows service or some scheduled task to call the web service.