Post reply

calling WCF Service in SQL 2008 Job

  • November 28, 2011 at 11:43 pm

    #251241

    Hi

    For a project I am trying to call WCF webservice in SQL 2008 Job for regular execution of the service.

    Please let me know the best way to call it.

  • November 29, 2011 at 12:01 am

    #1413806

    Here are a couple of options, I'm not sure which is the best.

    1. create a CLR stored proc and call the proc from a T-SQL job step.

    2. create a ssis package that has a script task. Call the service from the script task.

    3. generate a proxy for the WCF service, and call it using a powershell job step. I know this works in regular powershell, but it might not work in sqlps.

    Option 2 is probably the easiest.

    good luck.

Viewing 2 posts - 1 through 1 (of 1 total)

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