Autosys job in UNIX


 
Thread Tools Search this Thread
Top Forums Programming Autosys job in UNIX
Prev   Next
# 1  
Old 10-09-2017
Autosys job in UNIX

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.


Code:
 select * from emp where trunc(joining_date) = '16-AUG-17' and designation='MANAGER'  and EMP_NO='543498'
;

2 Email Format :
To: <Group 1>,<Member1>, <Group 3>
From: TEAM1,TEAM3
Email Subject: Notice1
Email content: <data return from above query>

Thanks,
Vasu
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Suggestion in Autosys job

Hi, I am new to Unix and Autosys. I have written Oracle query. Now I would like to create Autosys job. below is the requirement. Send in email every 30 minutes from 11 to 4:00 PM. E-mail should only be sent ONLY when below Query have data return. Email format: To: , From: , Email... (1 Reply)
Discussion started by: vasuvv
1 Replies

2. UNIX for Advanced & Expert Users

Autosys Job: Job did not start

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

3. UNIX for Advanced & Expert Users

list of job autosys

hi all would like to know a list of job in the my autosys . which is the command for extract it? thanks a lot regards FrancescoIt (1 Reply)
Discussion started by: FrancescoIt
1 Replies

4. Shell Programming and Scripting

Autosys Job Permission

Hi friends, Can anybody tell me the different type of permission used in autosys. thanks!!!!! (0 Replies)
Discussion started by: diehard
0 Replies

5. Shell Programming and Scripting

Autosys Job

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

6. UNIX for Dummies Questions & Answers

Autosys Job.

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

autosys job configuration for job failure.

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

8. UNIX for Advanced & Expert Users

Autosys job scheduling

Hi, I want to schedule a job through Autosys (in Linux server) to run on 1st day of every 3rd month(gap of 90 days). Please someone help me to achive my above requirement Example: Run the sample.sh on 01-Jan-2009, 01-Apr-2009, 01-Jul-2009, 01-Oct-2009. Thanks in advance (4 Replies)
Discussion started by: apsprabhu
4 Replies

9. UNIX for Advanced & Expert Users

Documentation and books on Autosys Job Control Tool from Autosys

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

10. Shell Programming and Scripting

Autosys job display

autorep -J dfile_252500_U_HSP_f2purge -w Job Name Last Start Last End ST Run Pri/Xit ________________________________________________________________ ____________________ ____________________ __ _______ ___ ... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies
Login or Register to Ask a Question
GLOBUS-JOB-STATUS(1)						  GRAM5 Commands					      GLOBUS-JOB-STATUS(1)

NAME
globus-job-status - Check the status of a GRAM5 job SYNOPSIS
globus-job-status JOBID globus-job-status [-help] [-usage] [-version] [-versions] DESCRIPTION
The globus-job-status program checks the status of a GRAM job by sending a status request to the job manager contact for that job specifed by the JOBID parameter. If successful, it will print the job status to standard output. The states supported by globus-job-status are: PENDING The job has been submitted to the LRM but has not yet begun execution. ACTIVE The job has begun execution. FAILED The job has failed. SUSPENDED The job is currently suspended by the LRM. DONE The job has completed. UNSUBMITTED The job has been accepted by GRAM, but not yet submitted to the LRM. STAGE_IN The job has been accepted by GRAM and is currently staging files prior to being submitted to the LRM. STAGE_OUT The job has completed execution and is currently staging files from the service node to other http, GASS, or GridFTP servers. OPTIONS
The full set of options to globus-job-status are: -help, -usage Display a help message to standard error and exit. -version Display the software version of the globus-job-status program to standard output. -versions Display the software version of the globus-job-status program including DiRT information to standard output. ENVIRONMENT
If the following variables affect the execution of globus-job-status. X509_USER_PROXY Path to proxy credential. X509_CERT_DIR Path to trusted certificate directory. BUGS
The globus-job-status program can not distinguish between the case of the job manager terminating for any reason and the job being in the DONE state. SEE ALSO
globusrun(1) University of Chicago 03/18/2010 GLOBUS-JOB-STATUS(1)