Run procedures automatically in SQL Express!

Опубликовано: 26 Ноябрь 2024
на канале: Data friendly
6,922
114

As you probably know, SQL Express does not have the functionality to run procedures automatically. But that's not a problem. And in this tutorial, I will show you why.

--------------------------------------------
TABLE OF CONTENTS
--------------------------------------------

00:00 - Intro
00:58 - Creating a new stored procedure
02:34 - New files in windows
02:51 - Creating a bat file
04:46 - Configuring bat file
07:14 - Configuring Windows task scheduler
10:33 - Test run for the newly created procedure
10:59 - Thank you for watching
11:53 - Fails

Like my video? Patreon link to support me, get extra perks, and download files I have created in my videos:   / datafriendly  

Gear I use:
Camera: https://amzn.to/30G0Ecp
Monitor: https://amzn.to/3kmrFtv
Laptop: https://amzn.to/33H49kV
External HDD I recommend: https://amzn.to/2PFgMEO

*I use affiliate links on the products that I recommend. These give me a small portion of the sales price at no cost to you. I appreciate the proceeds and they help me to improve my channel!