Forum Discussion

ritz's avatar
ritz
Advocate I
6 months ago
Solved

SQL Server Agent in Fabric Warehouse

Hello,   I'm one of the DEs in our analytics team and we are using Fabric as our main analytics solution for all the ETL.   I have a requirement to run astored procedure every 30 minutes on one o...
data pipeline
data warehouse
Warehouse
  • v-dineshya's avatar
    v-dineshya
    6 months ago

    Hi ritz ,

    Thank you for the update.  For most cost effective and less memory , please prefer below option.

     

    Data Pipeline --> Stored Procedure activity (scheduled with Job Scheduler).

     

    Their is no SQL server agent in fabric, you can use above option to acheive your desired result.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

ritz's avatar
ritz
Advocate I
6 months ago

Hi Dinesh,

 

Thanks for the detailed reply!

Our procedure looks very similar do the one you shared. Do you know which option would be the most cost-effective, and less memory-heavy?

We liked the idea of SQL Server Agent because it didn't have to being a session and connect to the db, but in Fabric we have  to go with a different approach then.

v-dineshya's avatar
v-dineshya
Community Support
6 months ago

Hi ritz ,

Thank you for the update.  For most cost effective and less memory , please prefer below option.

 

Data Pipeline --> Stored Procedure activity (scheduled with Job Scheduler).

 

Their is no SQL server agent in fabric, you can use above option to acheive your desired result.

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

  • oussamahaimoud's avatar
    oussamahaimoud
    Memorable Member
    4 months ago

    Very special thanks !