How to create an outlook task using SQL?
-
Dear All, I need to create a procedure that creates an outlook task for a set of domain users when some condition in the data base is fired. Is this possible? I am using SQL Server 2008 R2, Exchange Outlook 2010 Regards
Kind Regards OBarahmeh
Take a look at this article, it might give you a starting point. Sending Tasks Programmatically[^]
-
Take a look at this article, it might give you a starting point. Sending Tasks Programmatically[^]
-
Hi, I need to create the tasks through an SQL Server procedure and not using .NET Do u have any ideas about how to do this in a procedure inside the SQL Server? Regards
Kind Regards OBarahmeh
I'm afraid you won't be able to directly create a task through SQL Server, but I'm not an absolute expert at your requirement. However, this is how I might approach the problem. 1) In TSQL, there is a command called, xp_cmdshell, which allows you to execute a command shell 2) Create a command-line application that would take as command line parameters the values you need to create a Task. There are significant security issues related to enabling xp_cmdshell, so you may want to evaluate those issues first.