title: Stored procedure with parameter validation for job name
body: <p>I would like to create a stored procedure in SQL that executes only jobs that are specified in the parameter validation of the procedure itself. For example I would like my dev team to only be able to pass the job names that I specify that way they will be able to run the jobs they need only. From their perspective it will look something like this. </p>
  
  <pre><code>Exec sp_run_only_jobs myjob
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Exec sp_run_only_jobs myotherjob
  </code></pre>
  
  <p>if they try to run a job other than the two above it should fail with an error message.</p>
  
  <p>I</p>