Glenn Stearns
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Untitled-1.jpg