I have several agent jobs that it would be EXTREMELY helpful if Power Apps could run them (load and refresh some data from a feed).
Has anyone else done this? They would be on an SQL Server that lives in IaaS not as Azure SQL Service.
Agent jobs usually run as scheduled tasks. What you could try is to create stored procedures and run these from triggers in the table being updated by PowerApps data? Would that work?
Yes, that would be an option.
I take it there is no way to call a stored procedure from power apps directly?
That said, yeah I could make a table and then have the stored procedure UPDATE that table's record with "processing" and "completed" and then Power Apps could just refresh that view waiting for it to finish so the user gets confirmation when all is done.
No hablo ingles, pero lo puedes traducir …
CREATE PROCEDURE [dbo].[sp_start_jobV2] @JOB_name sysname AS BEGIN DECLARE @JOB_id_as_char VARCHAR(36) DECLARE @retval INT DECLARE @SteP_id INT DECLARE @JOB_owner_sid VARBINARY(85) DECLARE @JOB_id UNIQUEIDENTIFIER = NULL DECLARE @error_flag INT = 1 -- Set to 0 to suppress the error from sp_sqlagent_notify if SQLServerAgent is not running DECLARE @server_name sysname = NULL -- The specific target server to start the [multi-server] job on DECLARE @SteP_name sysname = NULL -- The name of the job step to start execution with [for use with a local job only] DECLARE @output_flag INT = 1 -- Set to 0 to suppress the success message
ALTER PROCEDURE [dbo].[llamar_job] @LLAMAR varchar (50) AS BEGIN exec msdb.dbo.sp_start_jobV2 @llamar END
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!