Schedule Task

Question

Dear all i am Danish Habib and i am developing a web application  in that i have to assign a maximum of ten days to user to submit his data after that time his visible bit becomes false and he will not be able to submit his dataWhat would be the mechanism If I calculate the days on that specific page and based on the days if i send a email as remainderthen this code would be run every time when the page hitsi do not want that the if the pages hits 1000 times then 1000 emails would be sent to him its bad. what would be the alternatives ??

Danish Habib · Answer

Thanks Dear

Priti Kumari · Answer

you need to alter one column in your particular table.like your table name is tblemployee.in this table add status column with value 0 and 1. insert 0 in particular column when you insert data in this table and after final submission you update that column value to 1. 0 show data pending for final submission. 1 shows data finaly submitted. After that you create SSIS package for sending remainder email to the particular. and run this SSIS package through Sql server agent JOB. Using job you can schedule your SSIS package. Using SSIS package you can easily done you work. If you are new in SSIS and sql job then you need to first learn these thing.

Danish Habib · Answer

Please respond if some one have an alternatives to