[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

Create Stored Procedure for SQL Script

I want to create a stored procedure to execute the following script:

UPDATE somast
set fcusrchr1 = fsono

Then I can use the stored procedure to create a SQL Agent job and schedule this to run automatically.

I think I can build the Agent job...just not sure how to create the stored procedure.

0
Glenn Stearns
Asked:
Glenn Stearns
1 Solution
 
mvgeertruyenCommented:
You can enter that command straight into the SQL job if you want to (just make sure to select the right database in the job).
0
 
Nathan RileyFounder/CTOCommented:
Go to the highlighted below, right click and new stored procedure:
Untitled-1.jpg
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now