Skip to main content

How to create a job in autosys using sample jil file

 

Hello Techie's

I know you are new to Autosys and want to know How to Create Job in Autosys using a jil file, Don't worry we are here with wonderful example and sample jil file.

Before going into the sample jil, you need some script to run via Autosys. you can use the sample powershell script written in our blog How to call stored procedure using powershell scripting using try and catch (vichietechie.blogspot.com)  or if you have your own script, you can use that as well.


Problem Statement:

1. you need to Run particular script on sheduled time.

2. you need to know whether the script executed without errors.

2. If executed with errors the sheduled job should send notification.


Prerequisties:

1. you must have CA Workload Automation Tool installed in your machine.

2. you must know the hostname & Uid of that machine.

3. you should have script to run in autosys.


what is the difference between box and job in autosys ?

A box is used to organize and control process flow of the jobs inside it. box are containers that hold jobs.

What is needed in the JIL File :

BOX Details

insert_job:
description:
owner:
date_condition:
days_of_week:
Start_times:
timezone: 
alarm_if_fail: 
send_notification:
max_run_alarm: 

JOB Details

insert_job:
description: 
machine:
owner:
box_name: 
max_run_alarm:
alarm_if_fail:
send_notification:
std_out_file:
std_err_file:
command:

What will below Sample JIL File do?

As a Example, I have created this JIL file to run the powershell script which calls the stored procedure present in db.
You guys can edit the values as per your requirement. but remember to use the same syntax.


Sample JIL File:

insert_job: archive_older_data_box
description: "Weekly Archive job"
owner: "uid"
date_condition: 1
days_of_week: sa
Start_times: "17:00"
timezone: "London"
alarm_if_fail: n
send_notification:
max_run_alarm: 0

insert_job: archive_older_data_job
description: "Weekly Archive job which calls Stored procedure which will archive tables"
machine: hostname
owner: "uid"
box_name: archive_older_data_box
max_run_alarm: 0
alarm_if_fail: y
send_notification: n
std_out_file: "d:\logs\Autosys\%Auto_JOB_NAME%.%AUTORUN%.out"
std_err_file: "d::\logs\Autosys\%Auto_JOB_NAME%.%AUTORUN%.err"
command: powershell -command "d:\Autosys\jobs\Runsp.ps1"

        

Do you Want to Know more about autosys command ?

click Here -> Autosys commands (vichietechie.blogspot.com)

        

Comments

Post a Comment

Popular posts from this blog

Curl command to check if file exists in s3 bucket

 Hello Techie's,  we can use below Shell script to check if particular file present in s3 bucket. # -------------------------------------------------------------------- #s3 Bucket Credentials #-------------------------------------------------------------------- s3_access_key=XXXXXXXXXXX s3_secret_key=XXXXXXXXXXX host=s3_bucket_api_url bucket=s3_bucket_name folder_name=name_of_the folder_in_bucket file_name=name_of_the_file_to_check #-------------------------------------------------------------------- #curl command variables #-------------------------------------------------------------------- dateValue=`date -R` contentType="application/xml" filepath="/${bucket}/${folder_name}/${file_name} signature_string="GET\n\${contentType}\n${dateValue}\n${filepath}" signature_hash=`echo -en ${signature_string} | openssl sha1 -hmac ${s3_secret_key} -binary | base64` #-------------------------------------------------------------------- #Curl command to check if file exi...
3 comments
Read more

How to link image pull secret to service account in openshift

Hello Techie's, If your services are running in ECS - Openshift container platform and you need to edit the credentials of the Image pull secret, please follow the below steps. What is Image Pull Secret ? It is used to pull an image from a private container image registry or repository to the deployment. How does the yaml file of Image Pull secret looks ? apiVersion: v1 kind: Secret metadata:   ...   name: secret_name   ... data:   .dockerconfigjson: eyJodHRwczovL2luZGV4L ... J0QUl6RTIifX0= type: kubernetes.io/dockerconfigjson Problem Statement: Let's say, you are updating the existing Image Pull Secret values -  for example, changing docker credentials of your repository or updating the uid password from 8 character password to 15 character.  As you make changes in exising secret, Deployments or build which you trigger will obviously fail.  To overcome that you need to link the updated Image Pull secret to the service account which are using that secr...
Post a Comment
Read more