When you need to Run Stored Procedure in a JOB

if object_id(N'usp_DefragIndexes') <>0
drop proc usp_DefragIndexes
go

CREATE PROC usp_DefragIndexes @databasename SYSNAME = null,
@maxfrag DECIMAL

as

-- @maxfrag = 10.0
BEGIN

IF @databasename is null
BEGIN
RETURN;
END

DECLARE @SQL nvarchar(4000)
SET @SQL = 'USE '+ @databasename +'
SET NOCOUNT ON
.......;'

DECLARE @Params nvarchar(4000)
SET @Params = N'
@databasename SYSNAME ,
@maxfrag DECIMAL'

EXECUTE sp_executesql @SQL,
@Params,
@databasename =@databasename ,
@maxfrag = @maxfrag
END