T sql question - Sajha Mobile
SAJHA MOBILE
T sql question
Posts 2 · Viewed 5913 · Go to Last Post
spring123
· Snapshot 0
Like · Likedby · 0
How can I do this?
I want to create a store proc which execute the result of:
Select name from sysjobs where name like 'myjobABC%'
Another words, just say the result of above is name = "myjobABC02018"
then I want
EXEC dbo.sp_start_job 'myjobABC02018'
phone
· Snapshot 104
Like · Liked by · 0
Hey @spring123,
Try this:-

CREATE PROCEDURE dbo.sp_start_job
@name nvarchar(30)
AS
Select name from sysjobs where name = @name
Go

EXEC dbo.sp_start_job 'myjobABC02018';
GO

OR(using wildcard)

CREATE PROCEDURE dbo.sp_start_job 
@name nvarchar(30)
AS
Select name from sysjobs where name Like + @name +'%'
Go

EXEC dbo.sp_start_job 'myjobABC%'; 
GO
Last edited: 27-Jul-18 02:45 PM
Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
Visitor from US is reading T sql question
Visitor from US is reading Urgent Treatment
Visitor is reading Will Patriots loose tonight ?
Visitor is reading Need a transportation from Minneapolis St. paul to Mankato
Visitor is reading Baburam and Bilateral treaty with India
Visitor from US is reading Nice Nepali Pop Song from TV Serial Biman Chalak Acoustic Ve
Visitor from US is reading Education - Why only Dr Baburam? what abt Deuba's LSE Degree
Visitor is reading Jal Shah in New York...
Visitor from US is reading Nice Nepali Pop Song from TV Serial Biman Chalak Acoustic Ve
You might like these other discussions...
sojho_bahun » Tesla guy
Nims- एक उन्मत्त साँढे
· Posts 4 · Viewed 267
Logan » GeetMaiJawaafDiu?
Now Trump is a convicted criminal .
· Posts 10 · Viewed 830 · Likes 1
apunge » ShreeRaam
TPS EAD auto extended to June 2025 or just TPS?
· Posts 9 · Viewed 1234
NepalNews Sajha
News Summary from Nepal for Friday, May 31, 2024
· Posts 1 · Viewed 90
Sajha Classifieds
Classifieds Summary: Jobs in CO, Room/Apt in MA
· Posts 1 · Viewed 100
NepalNews Sajha
News Summary from Nepal for Friday, May 31, 2024
· Posts 1 · Viewed 84
shrestha8 » wakeyour_mind
K Ho Israel ? Is Israel’s action justified?
· Posts 12 · Viewed 636
haal haal pandit » Tesla guy
whats wrong living with your parents ?
· Posts 25 · Viewed 4040 · Likes 2
salikram jamakattel » haal haal pandit
Why Nepali people stuck in TPS?
· Posts 3 · Viewed 674
haal haal pandit » haal haal pandit
Tik tak banned in US?
· Posts 3 · Viewed 610



Your Banner Here
Travel Partners
Travel House Nepal