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..
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.
Kind Regards,
Saurabh Sharma
only dead fish swim along the flow of river, learn to make your own way.
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread
i am developing an employee appraisal website which will contain questions regarding their performance and work done etc.
there are two kinds of employees:
- Permanent
- Probation
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??
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.
coolrikesh
Member
4 Points
14 Posts
PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking the ...
Apr 08, 2009 06:36 AM|LINK
hello!
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..
LuKiller
Participant
789 Points
170 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
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.
http://www.lukiller.net
saurabhsharm...
Member
742 Points
120 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
Apr 08, 2009 12:02 PM|LINK
Dear,
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.
Saurabh Sharma
only dead fish swim along the flow of river, learn to make your own way.
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread
saurabhsharm...
Member
742 Points
120 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
Apr 08, 2009 12:31 PM|LINK
please check the below links for the same
http://msdn.microsoft.com/en-us/library/zt39148a(VS.80).aspx
http://msdn.microsoft.com/en-us/library/zt39148a.aspx
Saurabh Sharma
only dead fish swim along the flow of river, learn to make your own way.
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread
coolrikesh
Member
4 Points
14 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
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..
dudeSreeni
Member
39 Points
39 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
Apr 09, 2009 03:16 AM|LINK
Hi cool,
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.
coolrikesh
Member
4 Points
14 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
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:
- Permanent
- Probation
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??
PLEASE HELP!
thanks again for all the advice till now...
dudeSreeni
Member
39 Points
39 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
Apr 09, 2009 04:50 AM|LINK
Hi,
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 http://www.sqlservercentral.com/Forums/Topic626594-1291-1.aspx
good luck
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
Apr 09, 2009 04:54 AM|LINK
Refer my article
on automatic emailing based on values in database
http://www.aspsnippets.com/post/2009/03/08/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx
Contact me
coolrikesh
Member
4 Points
14 Posts
Re: PLEASE HELP!!! URGENT .. will be very grateful... Problem : - to automatically keep checking ...
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!