run powershell code from stored proc to zip files

Question

Post reply

run powershell code from stored proc to zip files

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

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

Site Owners SSC Guru Points: 80412 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 2

Probably the easiest way to do it would be to have a SQL Agent job with your PowerShell code in it (a SQL Agent step can be PowerShell) and then use msdb.dbo.sp_start_job in your stored procedure to run that.