title: dbms_scheduler.run_job('jobName) fails to run
body: <p>I'm trying to run a scheduled job manually, the job looksa like this</p>
  
  <pre><code>  DBMS_SCHEDULER.CREATE_JOB (
     job_name           =&gt;  'UPDATE_PLAYER_STATES',
     job_type           =&gt;  'STORED_PROCEDURE',
     job_action         =&gt;  'PLAYER_STATE_UPDATER',
     repeat_interval    =&gt;  'FREQ=DAILY;BYHOUR=0', /* every day at Midnight */
     job_class          =&gt;  'DEFAULT_JOB_CLASS',
     enabled            =&gt;  true,
     auto_drop          =&gt;  false);
  </code></pre>
  
  <p>Now when I run the procedure using <code>execute PLAYER_STATE_UPDATER</code> I can see the desired result , but the job is failing to execute as shown by</p>
  
  <pre><code>select log_date, job_name, status, run_duration
  from dba_scheduler_job_run_details where job_name='UPDATE_PLAYER_STATES' or status='FAILED';
  
  
      LOG_DATE                    JOB_NAME        STATUS   RUN_DURATION 
  ------------- -----------------------------------------------------------------
  23-AUG-11 00.20.24.288887000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  22-AUG-11 10.27.24.537659000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  22-AUG-11 10.28.50.447042000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  22-AUG-11 10.30.30.018891000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  25-AUG-11 10.59.02.332579000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  25-AUG-11 10.59.15.980730000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  25-AUG-11 10.59.27.823131000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  25-AUG-11 11.01.04.798364000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  24-AUG-11 00.20.24.419251000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  25-AUG-11 00.20.24.299180000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  25-AUG-11 09.35.24.798535000 +01:00 UPDATE_PLAYER_STATES    FAILED    0 0:0:0.0    
  </code></pre>
  
  <p>And executing the job manually is failing too <code>dbms_scheduler.run_job('UPDATE_PLAYER_STATES');</code> with the error</p>
  
  <pre><code>Error starting at line 1 in command:
  dbms_scheduler.run_job('UPDATE_PLAYER_STATES')
  Error report:
  Unknown Command
  </code></pre>
  
  <p>What am I missing.</p>