August 30, 2018 at 1:15 pm
Hi,
Is it possible to call a php (or any web) page from SQL?
I have to create a script that will call a php page that runs a down stream process.
If this can be done easily I'd be interested in knowing.
Any help welcome.
Thanks,
Eamon
August 30, 2018 at 4:01 pm
Maybe an SSIS package that you call from a SQL agent job. You can invoke the job from SQL Server using a stored procedure.
https://social.msdn.microsoft.com/Forums/en-US/9aca958c-03b9-484f-b5ef-4d09159d3d0e/how-do-i-open-web-page-from-ssis
August 30, 2018 at 10:38 pm
You could do it from a Powershell job step, with something like:
Invoke-WebRequest -Uri http://www.google.com
August 30, 2018 at 11:57 pm
You could create a CLR proc that takes a URL, and makes the call
September 14, 2018 at 1:25 am
Hi, belated thanks for the great advice.
I went for the Powershell approach and set it up the job with a CmdExec job step which worked just fine.
Thanks again,
Emoan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply