• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • 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 RileyFounderCommented:
Go to the highlighted below, right click and new stored procedure:
Untitled-1.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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