473,396 Members | 2,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

exec dbms_jobs.run(:jobno) after executing this i got one error message

my coding
variable jobno number

begin
dbms_job.submit(job =>:jobno,
what => 'pack3.addpro(17,''syed'',23432,sysdate,300);',
next_date => SYSDATE + 30/86400,
interval => 'SYSDATE + 30/86400');
commit;

end;
/
print jobno
~


SQL> @autoadd.sql

PL/SQL procedure successfully completed.


JOBNO
----------
30

SQL> exec dbms_job.run(29);
BEGIN dbms_job.run(29); END;

*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 406
ORA-06512: at "SYS.DBMS_JOB", line 272
ORA-06512: at line 1
Aug 9 '07 #1
1 9123
debasisdas
8,127 Expert 4TB
Look at the alert log for details on which jobs failed and why.
Aug 9 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: IronMonk | last post by:
i cannot execute the exec command and pass varaible through it exec('/secure/sed_repl.sh "route add -host $obj->host device $device2" "" '); I have to execute it this way ......
1
by: Jianxin | last post by:
Hi, all, Can I run message pump in C# to yield cotrol to other window messages while my main thread is waiting for lengthy procesing to finish? In C++, PeekMessage(), TranslateMessage(), and...
0
by: DraguVaso | last post by:
Hi, I have a VBScript that I want to run from my VB.NET application. I initialize everything like this: AxScriptControl1.Language = "VBScript" AxScriptControl1.Reset()...
3
by: Dennis | last post by:
I start my applicaiton from sub Main as follows: <STAThread()>Public Sub Main() Dim MainForm As frm_Main = New frm_Main Application.Run(MainForm) End Sub In the MainForm, I show a Progress...
1
by: Mark Denardo | last post by:
Can someone explain the difference between starting an application using Application.Run() and using ShowDialog? Module MainModule Sub Main Dim f1 as New Form1 Application.Run(f1) End Sub...
3
by: Marc Solé | last post by:
Hello! I have a error that often appears. When I execute my windows program in debug mode, often appears an error in the Program.cs module, in sentence Application.Run. When I'm looking for the...
1
by: Eragon Shade Slayer | last post by:
When I Open Into Word (version Office Professional 2000) I Get Error Box Visual Basic Run Time Error 91 Appearing . I Deinstalled And Reinstalled Office 2000 But Error Message Comes Up Again Any...
2
by: CrystalBlue | last post by:
I've got a silly little problem when I'm trying to map a drive using shell script. Basically, I need the program to open up to a specific folder on a shared server and throw a zip file onto it, then...
0
AnuSumesh
by: AnuSumesh | last post by:
Hi All, I want to get MAC address of client machine. I am using folllowing code in asp using vbscript: Set objWshShell = Server.CreateObject("WScript.Shell") strToExec = "nbtstat -a " &...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.