automatically send a notice after 6 months (was "Date Question")

Hello,

I'm trying to write a query that will do the following... I'll give a quick background:

When a machine is installed, I record an installation date. We would like to automatically send a notice to our customers 6 months past this install date regarding scheduled maintenance.

Right now all I have is the notice, which is a report in Access with a query attached that pulls all machine sales that have install dates.

I'm not sure how to reference this situation... or how to start addressing the problem.

Basically:

Customer(CustomerID, CustomerName, CustomerEmail)
MachineDetail(DetailID, CustomerID, ModelID)
MachineModel(ModelID,ModelName)
InstallInfo(InstallID, DetailID, InstallComplete)

Please help :( Thanks,
CherishTry looking here (http://www.1keydata.com/sql/sql.html) or here (http://www.geocities.com/SiliconValley/Vista/2207/sql1.html) or here (http://www.w3schools.com/sql/default.asp).

;)|||use the DATEADD function
select ...
from ...
where InstallComplete
between dateadd("m",-6,date())
and dateadd("m",-5,date()) this will pull all installs between 5 and 6 months old

that way you can prepare the notices manually

sorry, no idea how to set up access to do this automatically

perhaps ask in the access forum|||Create a stored procedure starting with the code posted by r937, that selects the customers you want to send a notice to and either send an e-mail or write the notices to a file.

Create a batch script to execute this procedure ONCE per month, depending on your OS use:
1) Dos cmd and Win2K(XP) task scheduler or 2) Unix KSH and crontab or 3) Oracle jobs.

There have been many posts in this and other forums on how to send e-mail from either Oracle or MS SQL.
:rolleyes:

PS: Ooops, just noticed you mentioned Access...
I beleive you can e-mail the notices by having Access 'write' to Outlook.
Good Luck.|||LKBrwn_DBA, Access doesn't support stored procs|||LKBrwn_DBA, Access doesn't support stored procs
Yeah, I just noticed it was Access, but he can create a VB 'Procedure' or something like that. :(|||PS: Check these links:
MS Email FAQ (http://www.granite.ab.ca/access/email.htm) and MS ACCESS VB script (http://www.febooti.com/products/command-line-email/online-help/send-email-ms-access.html)
;)|||She, and thanks for all your help, I'll try out the suggestions today :)

Automatic Updates

OK, I get a message from Automatic Updates that SQL 2005 SP 2 needs to be
installed. I tell it to go ahead and install. It says it installed
successfully.
Ten minutes later I get a message from Automatic Updates that SQL 2005 SP 2
needs to be installed. I tell it to go ahead and install. It says it
installed successfully.
Ten minutes later I get a message from Automatic Updates that SQL 2005 SP 2
needs to be installed. I tell it to go ahead and install. It says it
installed successfully.
I reboot just for the heck of it.
After I reboot I get a message from Automatic Updates that SQL 2005 SP 2
needs to be installed. I tell it to go ahead and install. It says it
installed successfully.
This has been going on for two weeks now. Any ideas?Hi Mike
"Mike C#" wrote:
> OK, I get a message from Automatic Updates that SQL 2005 SP 2 needs to be
> installed. I tell it to go ahead and install. It says it installed
> successfully.
> Ten minutes later I get a message from Automatic Updates that SQL 2005 SP 2
> needs to be installed. I tell it to go ahead and install. It says it
> installed successfully.
> Ten minutes later I get a message from Automatic Updates that SQL 2005 SP 2
> needs to be installed. I tell it to go ahead and install. It says it
> installed successfully.
> I reboot just for the heck of it.
> After I reboot I get a message from Automatic Updates that SQL 2005 SP 2
> needs to be installed. I tell it to go ahead and install. It says it
> installed successfully.
> This has been going on for two weeks now. Any ideas?
>
What version is your SQL Server at? Do you have any other instances?
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
explains the different versions and actions that should be taken including
not allowing Microsoft Update to apply SP2 if you have a hotfix that didn't
make SP2.
You could try applying http://support.microsoft.com/Default.aspx?Kbid=934459
John|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7A1CB953-70DF-4746-BCC5-11EF82180579@.microsoft.com...
> Hi Mike
> "Mike C#" wrote:
>> OK, I get a message from Automatic Updates that SQL 2005 SP 2 needs to be
>> installed. I tell it to go ahead and install. It says it installed
>> successfully.
>> ...
> What version is your SQL Server at? Do you have any other instances?
> http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
> explains the different versions and actions that should be taken including
> not allowing Microsoft Update to apply SP2 if you have a hotfix that
> didn't
> make SP2.
> You could try applying
> http://support.microsoft.com/Default.aspx?Kbid=934459
> John
Hi John,
9.00.3054. I'll check out the post, and let you know if it helps. Thanks!
Mike|||Hi
"Mike C#" wrote:
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7A1CB953-70DF-4746-BCC5-11EF82180579@.microsoft.com...
> > Hi Mike
> >
> > "Mike C#" wrote:
> >
> >> OK, I get a message from Automatic Updates that SQL 2005 SP 2 needs to be
> >> installed. I tell it to go ahead and install. It says it installed
> >> successfully.
> >> ...
> > What version is your SQL Server at? Do you have any other instances?
> >
> > http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
> > explains the different versions and actions that should be taken including
> > not allowing Microsoft Update to apply SP2 if you have a hotfix that
> > didn't
> > make SP2.
> >
> > You could try applying
> > http://support.microsoft.com/Default.aspx?Kbid=934459
> >
> > John
> Hi John,
> 9.00.3054. I'll check out the post, and let you know if it helps. Thanks!
> Mike
>
If it doesn't work, you can tell windows update not to remind you of a patch
again, when you go through the custom installation, selecting the download
and checking the "Don't remind me again" checkbox.
Johm|||"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:D6CFE0F8-8E64-4CD3-8004-7274A391A9C6@.microsoft.com...
> If it doesn't work, you can tell windows update not to remind you of a
> patch
> again, when you go through the custom installation, selecting the download
> and checking the "Don't remind me again" checkbox.
> Johm
I considered that, but decided against for now since I want to see if the
manual install actually works. I performed the manual install, and it
appears to have worked, but I want to give it a few more days to be sure.
Thanks
Mike

Auto Updates for SQL Server?

Our IT guy insists that he must be present anytime the SQL Server automatic updates from Microsoft are installed on the server or the server will crash. What has he been tinkering with to cause this to happen or is he just giving us a line?

Well, I wouldn′t apply all patches to SQL Server without any notice ot testing. Normally the updates or patches don′t break the functionality of SQL Server. To be sure, I would test the patch on a testing server. If you have a WUS, you can setup the server to confirm the patch first before applying the patch on the SQL Server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||I guess I needed to be a little more specific. He is referring to the auto updates which come from Microsoft (just like on a personal PC). He evidently has the server set up so that the updates sit there until he decides to install them (like the option on a personal PC) which isn't really the problem but then he has turned around and is saying that when he does install the updates (rather than anyone with knowledge to do so) he absolutely has to be there or the server will crash. What could he have possibly done which would make the server crash if he doesn't personally oversee the update process?|||

hi,

this sounds kind "confusing"...

does he perform particular steps in order to avoid "system crashes"?

regards

|||I don't have any idea. We're assuming he's just feeding us a line but he has an unusual family history (which has us particularly concerned at the moment). Believe me this is not a joke. We are not a Dept. of Defense facility or anything like that but we are just a small business where the owner hired him because of his computer knowledge (but does know his background). Now the owner is concerned this is coming back to bite him if we can't figure out why he needs to be there when any updates are installed. We are very worried that he has planted some type of code to bring the business to its knees. Other than a disaster recovery plan which I am already looking into, what other ideas would anyone suggest. I don't want to get anymore specific than what I have since I don't know whether he reads these forums or not.|||

I'm not sure this is a productive discussion for this forum. No one here could (or should) offer any suggestiona as to what your IT guy might or might not do to a computer to make it crash. If you have significant concerns about one of your employees, you need to take it up with your boss. If you feel it is a real possibility that your IT guy might do something maliceous to your server, you should have a qualified computer technician take a look at it.

Regards,

Mike Wachal
SQL Express team

FWIW: There are no patches for SQL Express available through Microsoft Update at this point, you have to download and apply them manually.