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'

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