T sql question - Sajha Mobile
SAJHA MOBILE
T sql question
Posts 2 · Viewed 5858 · 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 is reading Pandra Gatae Nepali TV serial - "Saye Thari Baaja Yeutai Taa
Visitor from US is reading Wanted --- Pawankali
Visitor from US is reading Happy Birthday thapap :o) !
Visitor from US is reading Sajha Looks Like a Maize
Visitor is reading Biggest buffoon of Nepal
Visitor from US is reading chicken chili recipe
Visitor from US is reading यो देशको काट्टो खानेहरुले !
Visitor from US is reading Tribute to Mehaboob Alam for the Perfect 10
You might like these other discussions...
haal haal pandit
whats wrong living with your parents ?
· Posts 1 · Viewed 43
tps8249 » Tesla guy
Trump has promised an immigration crackdown if reelected
· Posts 4 · Viewed 281
sajalshakya » Tesla guy
KTM hookah places
· Posts 2 · Viewed 290
Sajha Classifieds
Classifieds Summary: Room/Apt in MA,VA
· Posts 1 · Viewed 65
polisci
Same person that promoted Ivermectin was for horses is now taking it
· Posts 1 · Viewed 91
NepalNews Sajha
News Summary from Nepal for Wednesday, May 15, 2024
· Posts 1 · Viewed 67
Polisci
Pfizer says they are sorry
· Posts 1 · Viewed 113
trekkinghub » damar
Annapurna Base Camp Trek, 13 Days Cost for 2024 and 2025
· Posts 2 · Viewed 314
haal haal pandit » haal haal pandit
EB2 EB3 visa green card takes 10 years for Nepal
· Posts 12 · Viewed 1809
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 121



Your Banner Here
Travel Partners
Travel House Nepal