Schedule Task
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 data,What would be the mechanism ,If I calculate the days on that specific page and based on the days if i send a email as remainder,then this code would be run every time when the page hits,i 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 HabibPosted Nov 18, 2014, 7:04 AM
Priti KumariPosted Nov 10, 2014, 5:53 AM
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 HabibPosted Nov 9, 2014, 2:36 PM