Post reply

How to create an Exchange Outlook task for domain users using SQL?

  • January 20, 2011 at 5:56 am

    #230668

    Dear All,

    I need to create an Outlook Task for some domain users using SQL procedure.

    This procedure should be executed if some condition in the data base is fired .

    Any body has an Idea?

  • January 20, 2011 at 7:54 am

    #1275946

    Best solution is to use a trigger if it is a specific event in one table.

    Create an SSIS task for the Email alert, using the "SendMail Task"

  • January 20, 2011 at 2:40 pm

    #1276264

    McSQL (1/20/2011)

    Best solution is to use a trigger if it is a specific event in one table.

    Create an SSIS task for the Email alert, using the "SendMail Task"

    Unfortunately, the condition where the procedure will fire after is depending on more than one table with complicated queries. So, I need to create a trigger which will create Exchange tasks for some domain users when some conditions in the procedure are fired.

    Any Ideas, plz?

  • January 20, 2011 at 4:13 pm

    #1276303

    Yeah, whatever conditions you need to create in the job, just build them into an SSIS package, and then fire it off with the trigger?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply