Posted by: phone July 27, 2018
Login in to Rate this Post:
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
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