Hi all,
I have a SQL Server Job that I would like to run when I receive an email saying "Data is now ready to be imported to SQL Server" ?
Is there a way to accomplish this.
- Vivekgot a mapi compliant mail server laying around. you might be able to do this with sqlmail.
OR
i have never written too much VBA for outlook (mostly access and excel) but you maybe able to write a rule that drops this email in a certain folder. Then, and I am not sure if there is an event for new mail but there probably is, you can probably make a db call in that event. you would have to leave your mail client open and your computer on.|||Check out xp_readmail in SQL BOL. Basically, you would need to put this inside a SQL Job that executes periodically and then use xp_readmail to "answer" the inbox and trigger your job.
Having said all that, I will say that SQL mail only ever caused me grief and heartache. Go Database Mail (SQL 2004)!
Regards,
hmscott
Showing posts with label receipt. Show all posts
Showing posts with label receipt. Show all posts
Thursday, February 16, 2012
Subscribe to:
Posts (Atom)