sending mail using sqlserver2000 automatically i.e by 12:00am
-
hi, Well i am using the sqlserver2000 as backend. I have table like seatdetails and columns are seatno,bookingdate,dateoftravel,seatstatus the seatstatus can be 0 - rejected, 1 -pending, and 2 - accepted. Now the issue is daily at 12:00am , i need to execute the trigger or event which should check the dateoftravel with the date in server if it is less then check the status of a seat if it is 1 (i.e status of a seat) then the date diff of bookingdate and cureentdate if it is equal to 3 (i.e. counter of days) then the status should be set to 0 (i.e. status of a seat) and mail sent to @mailid1 and @mailid2 regarding the changes from the sqlserver. Thank you for helping me in advance You can mail me the procedure suhailquadri@gmail.com
-
hi, Well i am using the sqlserver2000 as backend. I have table like seatdetails and columns are seatno,bookingdate,dateoftravel,seatstatus the seatstatus can be 0 - rejected, 1 -pending, and 2 - accepted. Now the issue is daily at 12:00am , i need to execute the trigger or event which should check the dateoftravel with the date in server if it is less then check the status of a seat if it is 1 (i.e status of a seat) then the date diff of bookingdate and cureentdate if it is equal to 3 (i.e. counter of days) then the status should be set to 0 (i.e. status of a seat) and mail sent to @mailid1 and @mailid2 regarding the changes from the sqlserver. Thank you for helping me in advance You can mail me the procedure suhailquadri@gmail.com
Set up a SQL job that executes at 12:00am every day. As for the code, I hope you're not asking someone to write that for you. You claim to be a developer, so why can't you do it yourself? I suggest you make an attempt at it and post again if you have specific problems. Otherwise people will think you are another lazy developer who can't be bothered to do their own work and ignore your post.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
-
Set up a SQL job that executes at 12:00am every day. As for the code, I hope you're not asking someone to write that for you. You claim to be a developer, so why can't you do it yourself? I suggest you make an attempt at it and post again if you have specific problems. Otherwise people will think you are another lazy developer who can't be bothered to do their own work and ignore your post.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
well this can be done using code behind file. but i heard we can do it using sqlserver2000 enterprize manager if u have any idea regarading that , please help me
-
well this can be done using code behind file. but i heard we can do it using sqlserver2000 enterprize manager if u have any idea regarading that , please help me
suhailahmedmohammed wrote:
well this can be done using code behind file. but i heard we can do it using sqlserver2000 enterprize manager if u have any idea regarading that , please help me
RTFM
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
-
hi, Well i am using the sqlserver2000 as backend. I have table like seatdetails and columns are seatno,bookingdate,dateoftravel,seatstatus the seatstatus can be 0 - rejected, 1 -pending, and 2 - accepted. Now the issue is daily at 12:00am , i need to execute the trigger or event which should check the dateoftravel with the date in server if it is less then check the status of a seat if it is 1 (i.e status of a seat) then the date diff of bookingdate and cureentdate if it is equal to 3 (i.e. counter of days) then the status should be set to 0 (i.e. status of a seat) and mail sent to @mailid1 and @mailid2 regarding the changes from the sqlserver. Thank you for helping me in advance You can mail me the procedure suhailquadri@gmail.com
suhailahmedmohammed wrote:
hi, Well i am using the sqlserver2000 as backend. I have table like seatdetails and columns are seatno,bookingdate,dateoftravel,seatstatus the seatstatus can be 0 - rejected, 1 -pending, and 2 - accepted. Now the issue is daily at 12:00am , i need to execute the trigger or event which should check the dateoftravel with the date in server if it is less then check the status of a seat if it is 1 (i.e status of a seat) then the date diff of bookingdate and cureentdate if it is equal to 3 (i.e. counter of days) then the status should be set to 0 (i.e. status of a seat) and mail sent to @mailid1 and @mailid2 regarding the changes from the sqlserver.
That's a pretty nice novel you have there. Now, what exactly is your question? I.E., where in writing the code for this are you having problems?
suhailahmedmohammed wrote:
You can mail me the procedure suhailquadri@gmail.com
WHAT? Do your work yourself. This isn't rent-a-coder. This is a place where you ask specific questions when you are having specific problems. I can't wait until my device is finished.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet. "If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer