When running the job from stored proc I am getting the below error ..Can some one help me on that.
Request to run job (from User 'abc') refused because the job already has a pending request from User 'abc'.
IF NOT EXISTS(select * from msdb..sysjobhistory where job_id='9DDEWE' and run_status=4 )
exec sp_start_job @job_name = 'TEST'
Its the Journey which gives you Happiness not the Destination-- Dan Millman