04-11-2006
I saw it!!!
I wrote insert instead of update
any way thanks!!!!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have done kill-9 xxx for a job which is running in Autosys.
But when i use autorep -j xxx it is showing the job is in run status.
How to kill a job in Autosys which is in running status..
Thanks
Arun (3 Replies)
Discussion started by: arunkumar_mca
3 Replies
2. UNIX for Advanced & Expert Users
My project uses Autosys.
I am new to this product and I don't know where to start from.
Q1. Please provide me the link where I can get Autosys documentation
Q2. Please refer a good book on Autosys. (Beginner/Intermediate Level) (0 Replies)
Discussion started by: gram77
0 Replies
3. UNIX and Linux Applications
Hello!
I will be working with Autosys and I am looking for individuals that have knowledge of this UNIX application.
Thank-you! (3 Replies)
Discussion started by: preshe79
3 Replies
4. Shell Programming and Scripting
Hi,
I am trying to schedule an autosys job for weblogic server reboot. When i run the job it is failing with the following error:
/bin/sh: /path/stop_wls instancename: not found
The following is my jil and i dont refer to /bin/sh at all
update_job: mgd_shutdown_cmd.jil job_type: c ... (3 Replies)
Discussion started by: userscript
3 Replies
5. Shell Programming and Scripting
We need to configure autosys that when a job fails continously for 3 times, we need to call another job.
Is this possible in Autosys, or can anyone advice on the alternative. (2 Replies)
Discussion started by: sangea
2 Replies
6. UNIX for Dummies Questions & Answers
Hi Can any one tell me free online good book for autosys job.
Also whats the basic difference between Autosys job and cron job.
Thanks in advance. (2 Replies)
Discussion started by: diehard
2 Replies
7. Shell Programming and Scripting
I need to know the list of autosys job that run between given time.
I have the following command.
job_depends -t -J abc% -F "12/25/2010 03:00" -T "12/26/2010 05:00"
Above command will give the list of job that run between time 3 AM and 5 AM.
But the it gives me in random order how to... (1 Reply)
Discussion started by: diehard
1 Replies
8. Shell Programming and Scripting
Hi friends,
Can anybody tell me the different type of permission used in autosys.
thanks!!!!! (0 Replies)
Discussion started by: diehard
0 Replies
9. UNIX for Advanced & Expert Users
I have submitted an autosys job and force start it. Autosys hit the job 4 times to restart but it did not start and finally I terminate the job. Any idea why the job did not start. Below is the code I executed.
1214 missun0ap /export/home/bzn97r/develop/dswi/jil$ sendevent -E FORCE_STARTJOB... (0 Replies)
Discussion started by: jnrohit2k
0 Replies
10. Programming
Hi all,
I am new to Unix.
I would like to create a Autosys job in Unix. Can you please suggest.
below is the requirement.
1. Need t Send in email every 30 minutes from 11 am to 3:00 PM. E-mail should only be sent ONLY when below Query have data return.
select * from emp where... (1 Reply)
Discussion started by: vasuvv
1 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::trigger
SQL::Translator::Schema::Trigger(3pm) User Contributed Perl Documentation SQL::Translator::Schema::Trigger(3pm)
NAME
SQL::Translator::Schema::Trigger - SQL::Translator trigger object
SYNOPSIS
use SQL::Translator::Schema::Trigger;
my $trigger = SQL::Translator::Schema::Trigger->new(
name => 'foo',
perform_action_when => 'before', # or after
database_events => [qw/update insert/], # also update, update_on, delete
fields => [], # if event is "update"
on_table => 'foo', # table name
action => '...', # text of trigger
schema => $schema, # Schema object
scope => 'row', # or statement
);
DESCRIPTION
"SQL::Translator::Schema::Trigger" is the trigger object.
METHODS
new
Object constructor.
my $schema = SQL::Translator::Schema::Trigger->new;
perform_action_when
Gets or sets whether the event happens "before" or "after" the "database_event".
$trigger->perform_action_when('after');
database_event
Obsolete please use database_events!
database_events
Gets or sets the events that triggers the trigger.
my $ok = $trigger->database_events('insert');
fields
Gets and set which fields to monitor for "database_event".
$view->fields('id');
$view->fields('id', 'name');
$view->fields( 'id, name' );
$view->fields( [ 'id', 'name' ] );
$view->fields( qw[ id name ] );
my @fields = $view->fields;
table
Gets or set the table on which the trigger works, as a SQL::Translator::Schema::Table object.
$trigger->table($triggered_table);
on_table
Gets or set the table name on which the trigger works, as a string.
$trigger->on_table('foo');
action
Gets or set the action of the trigger.
$trigger->action(
q[
BEGIN
select ...;
update ...;
END
]
);
is_valid
Determine whether the trigger is valid or not.
my $ok = $trigger->is_valid;
name
Get or set the trigger's name.
my $name = $trigger->name('foo');
order
Get or set the trigger's order.
my $order = $trigger->order(3);
scope
Get or set the trigger's scope (row or statement).
my $scope = $trigger->scope('statement');
schema
Get or set the trigger's schema object.
$trigger->schema( $schema );
my $schema = $trigger->schema;
compare_arrays
Compare two arrays.
equals
Determines if this trigger is the same as another
my $is_identical = $trigger1->equals( $trigger2 );
AUTHORS
Anonymous, Ken Youens-Clark <kclark@cpan.org>.
perl v5.14.2 2012-01-18 SQL::Translator::Schema::Trigger(3pm)