Web Services Or Sql jobs RRS feed

  • Question

  • User1052662409 posted

    Hi All,

             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.


    Tuesday, April 24, 2012 2:14 AM


  • User2105670541 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 24, 2012 3:07 AM