/*
How to drop a scheduler job? Check this one out
*/
BEGIN
DBMS_SCHEDULER.DROP_JOB (job_name => 'test_job');
END;
/
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Execute your life day to day...you might not know what u're dropping ...-Cik Peah
State Machine Workflow
1. surf using keyword: workflow foundation in codeplex
2. check DinnerNow
2. check DinnerNow
Hello World..
Hi..my name if Fiza a.k.a Peah..I have involved in the software development world for almost 10 years now. I do freelance once in a while to keep up with the technology and I can be labeled as a free-thinker in the IT world..I did vb6, asp, php..involved in several databases mysql, postgresql, sql server...currently i am kinda in tact with oracle..Of all the above, I have deep interest in manipulating triggers, packages, functions, stored procedures...in any required dbms...and I also found that MOSS is fun to be discovered..
SQL Fundamentals: Reference
Pepstroops Library
SharePoint Designer Workflow Reference
Recent Comments
A Development DBA
Usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL. That can be satisfying at a human level because you are part of a team and you share the satisfaction of the team's accomplishments.
A Production DBA
Is responsible for maintaining Databases within an organisation, so it is a very difficult and demanding job. He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running.
Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction. But it's a more 'lonely' job than being a Development DBA.
SharePoint Masters
Oracle Reference
My Other Blogs
Labels
- Advance MOSS 2007: Reference
- Advance MOSS 2007: Web Service
- External Table
- Financial Tips
- How To Paste Your Code Snippet in Blogspot.
- Managing Enterprise Content
- MOSS 2007: Reference
- MOSS 2007: Today I Learn MOSS
- MOSS: Templates
- MS Project 2007: New Project
- MS Project 2007: Today I learn MS Project
- Oracle 10g: Alter Table
- Oracle 10g: Backup + Restore
- Oracle 10g: CASE...WHEN statement
- Oracle 10g: Concate Strings
- Oracle 10g: Connected Sessions
- Oracle 10g: Create Database
- Oracle 10g: Data Migration
- Oracle 10g: Database Data Source
- Oracle 10g: Database Scheduler
- Oracle 10g: Dates
- Oracle 10g: DBLINK
- Oracle 10g: IN Operator
- Oracle 10g: Installation
- Oracle 10g: Show All Tables Command
- Oracle 10g: SQL*PLUS
- Oracle 10g: Stored Procedure
- Oracle 10g: String Aggregation
- Oracle 10g: Trigger
- Oracle 10g: Uppercase + Lowercase
- Oracle 10g: Temporary Table
- oracle 11g: Creating Other Schemas Objects
- Oracle 11g: Installing Sample Schemas
- Oracle 11g: Using DDL Statements to Create and Managing Tables
- Oracle 11g: Using Single-Row Functions to Customize Output
- Oracle 22g: Manipulating Data
- Oracle Loader
- Ramble
- SharePoint 2010
- SQL Fundamentals
- Web Reference
Blog Archive
-
▼
2008
(32)
-
▼
January
(16)
- Oracle 10g: MONTHS_BETWEEN
- Oracle 10g: DBMS_SCHEDULER.DROP_JOB
- Oracle 10g: View All Scheduler Jobs
- Oracle 10g: DBMS_Scheduler.create_job
- Oracle 10g: Create Trigger
- Oracle 10g: Create If-else within SQL Query
- Oracle 10g: Initcap
- Oracle 10g: DBLINK
- Oracle 10g: Displaying All Connected Sessions
- Oracle 10g: Database Data Source
- Oracle 10g: Concatenation Operator (||)
- Oracle 10g: Concatenate(Concat)
- Oracle 10g: Backup & Restore (dump file)
- Oracle 10g: Executing Stored Procedure(Get)
- Oracle 10g: Execute Stored Procedure(Add)
- Oracle 10g: Create New Package
-
▼
January
(16)
1 comment:
Hello,
I'm working with Oracle Scheduler's interfacing with J2EE application.
Do you have any information about how to Manually rollback the job, chains, rules, actions etc. incase of any exception, in the middle of our block; where few of the oracle APIs are called and few were left. I see oracle immediately committing after each API call.
Any pointer will be appreciative.
Regards,
Ayesha Nosher
Post a Comment