cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Possible to run an SQL Agent Job?

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.

6 REPLIES 6
Highlighted
Helper I
Helper I

Re: Possible to run an SQL Agent Job?

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?

Highlighted
Frequent Visitor

Re: Possible to run an SQL Agent Job?

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.

Highlighted
New Member

Re: Possible to run an SQL Agent Job?

That would be very nice if that was possible. I'm also looking for something like this

Highlighted
Helper I
Helper I

Re: Possible to run an SQL Agent Job?

I read somewhere just recently that there was a way to now call stored procs from PowerApps. 

 

Does anyone one know how this can be done?

Highlighted
Frequent Visitor

Re: Possible to run an SQL Agent Job?

That would be helpful. I need this functionality also. Otherwise the trigger on value change idea will be necessary but not very neat as we are looking for code free solutions from Power apps.
Highlighted
Frequent Visitor

Re: Possible to run an SQL Agent Job?

Solved - The SQL Server connector does have this operation as standard. Namely Operation ID: ExecuteProcedure Called Execute Stored Procedure

 

Let's try it out.  Let me know how you go.

 

David Taylor

FAST LANE BUSINESS INTELLIGENCE

www.fastlanebi.com

 

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,860)