Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.oracle.misc > #821

Re: dbms_job not running at sqlplus shell

Show all headers | View raw

On Wednesday, March 26, 2014 9:44:10 PM UTC-6, Chek Ban Tan wrote:
> Hi,
> 
> 
> 
> I'm trying to run dbms_job at sqlplus shell but failed. In Toad i managed to run this at "Editor"->"Execute statement"
> 
> 
> 
> exec dbms_job.isubmit(1234, 'TEST;',SYSDATE,INTERVAL => 'SYSDATE+(2/24/60)');
> 
> /
> 
> successfully
> 
> 
> 
> But when i run
> 
> 
> 
>     [abc]$ sqlplus user/password @compile1.sql
> 
> 
> 
>     compile1.sql's content    
> 
>     spool compile.log;
> 
>     @try.sql
> 
>     spool off;
> 
> 
> 
> try.sql's content
> 
> 
> 
> exec dbms_job.isubmit(1234, 'TEST;',SYSDATE,INTERVAL => 'SYSDATE+(2/24/60)');
> 
> /
> 
> 
> 
> after runnning compile1.sql, this appears
> 
> 
> 
> [abc]$ sqlplus ESERV/ESERV @compile1.sql
> 
> 
> 
> SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 28 13:46:11 2014
> 
> 
> 
> Copyright (c) 1982, 2013, Oracle.  All rights reserved.
> 
> 
> 
> 
> 
> Connected to:
> 
> Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
> 
> With the Partitioning, OLAP, Data Mining and Real Application Testing options
> 
> 
> 
> 
> 
> and it stucked there forever. I did try to include begin ... end;
> 
> 
> 
> but still it doesn't succeed , kindly advise if you have any idea, thanks !
> 
> 
> 
> regards, Tan


Are you trying to run this in the same database?  If you got it to run from the SQL> prompt and are trying to get it to run again it won't, but it should have displayed an error that the job already exists.


What privileges does the ESERV user have?

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

dbms_job not running at sqlplus shell Chek Ban Tan <chekban@gmail.com> - 2014-03-26 20:44 -0700
  Re: dbms_job not running at sqlplus shell ddf <oratune@msn.com> - 2014-03-28 10:53 -0700
    Re: dbms_job not running at sqlplus shell Chek Ban Tan <chekban@gmail.com> - 2014-03-31 03:42 -0700
      Re: dbms_job not running at sqlplus shell joel garry <joel-garry@home.com> - 2014-03-31 09:16 -0700
        Re: dbms_job not running at sqlplus shell Chek Ban Tan <chekban@gmail.com> - 2014-04-01 18:01 -0700
          Re: dbms_job not running at sqlplus shell ddf <oratune@msn.com> - 2014-04-02 10:34 -0700
          Re: dbms_job not running at sqlplus shell joel garry <joel-garry@home.com> - 2014-04-02 13:55 -0700

csiph-web