exec dbms_job.broken(690,true);
where 690 is the job number obtained from
select * from dba_jobs
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Technical tid-bits and more ! Leave a comment if you found something useful.
Share
Labels
- ant (1)
- bash (10)
- bestpractise (2)
- browsers (1)
- code (1)
- commandline (11)
- cricket (1)
- database (1)
- dba (7)
- eclipse (2)
- editor (1)
- emacs (1)
- find (1)
- firefox (1)
- http (1)
- india (1)
- java (3)
- javascript (1)
- jquery (1)
- links (1)
- linux (17)
- network (3)
- oracle (17)
- performance (1)
- rails (1)
- regex (1)
- ruby (2)
- search (1)
- sed (3)
- shell-scripts (2)
- sql (9)
- svn (1)
- sysadmin (2)
- tools (1)
- unix (17)
- vim (19)
- web (1)
- webservices (1)
- windows (2)
- xmllint (1)
2 comments:
Dont forget to commit after executing this command.
good catch , a commit is required after the dbms_job.broken proc call.
Post a Comment