Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 20, 2009 10:30 AM by malcolms
Apr 08, 2009 06:36 AM|LINK
i am developing a project on staff appraisal using C# wherein i need to check whether the date of submission of the form has arrived or not.
this needs to be done everyday.
so i need to create a process or something which runs continuously in the background and checks the status at regular intervals of time.
suppose the submission date is 30th april,2009 (stored in sql database) and todays date is 8th april.. so i want to develop something which will compare the current date with the submission date everyday at some particular time of the day..
Apr 08, 2009 11:52 AM|LINK
You can make a job in SQL that checks this with a wuery and send an email with the summary. You can schedule the job to run whenever you want.
Apr 08, 2009 12:02 PM|LINK
you can create a window service very easily for this and apply timer which will check the status daily or accordingly set by you, if you still require any futher information then please let me know.
Apr 08, 2009 12:31 PM|LINK
please check the below links for the same
Apr 08, 2009 05:04 PM|LINK
hey.. thanks for the advice..
but i am working on a website. wud the links u posted work on it?
my website is almost over just this part is remaining..
Apr 09, 2009 03:16 AM|LINK
You have mentioned the requirement partially. Need more details like
-when u want to show this status i.e. the form submission deadline. say for example <b>the user logs-in to the application</b>.
Would be easy if u give further detail.
Apr 09, 2009 04:14 AM|LINK
ok. i will tell everything in detail..
i am developing an employee appraisal website which will contain questions regarding their performance and work done etc.
there are two kinds of employees:
the permanent employees need to fill their forms once every year and the probation employees need to fill their forms
every six months from their date of joining.
so i need to send a automatic email reminder to the concerned employees 15 days before the submission date... and
subsequent reminders everyday till the submission date..
and once the submission date elapses the submission should not be allowed.. the Submit button should be disabled...
so i need some sort of system for my website that keeps checking everyday whether its 15 days before the submission date and if it is then enable the submit button
and if the date is crossed then disable the submit button... how can i do all this??
thanks again for all the advice till now...
Apr 09, 2009 04:50 AM|LINK
This can be done in two ways
1) windows service - Invoke a service that executes around a particular time , checks the records in the table for the criterion and sends the msg thro mail module
2) thro a job in sql server- sql server 2005 has an option for sending mails. schedule a
job in sql server to get all the rows matching the criterion and send the mail from sql server.
for the later method hope the below link may help you
Apr 09, 2009 04:54 AM|LINK
Refer my article
on automatic emailing based on values in database
Apr 10, 2009 03:39 AM|LINK
your reply was very helpful..
the sqlserver job scheduler thing seems very nice but there's a problem.... we are using ORACLE 10g and NOT Sql Server!!! for database work..
Is there anything similar in oracle..??
please let me know soon...
thanks a ton for all the replies... your efforts are highly appreciated!