Skip to main content

Posts

Showing posts from August, 2022

How to clone and push in git with pull requests

Hello Techie's If you are wondering like how to use Git to connect to remote repository and how the brancing strategy works, you are in the right place. All you need to do is follow the steps mentioned below. Here we push a code from local git to github repository. Step 1:  Create a folder named git in your Home Directory on local machine. C:\Users\home\git Step 2:  Kindly provide the remote repository path URL  git clone <URL> Step 3: Kindly provide the Branch name where you need to edit the code, Because As a developer you should not edit the code in Master Branch. so we are switching to other Branch, you can switch to Featured Branch. git switch <Branch name> Step 4: Place your code using File explorer to your repository path C:\Users\home\git\repository_name Step 5:  Below command help to check what are the uncommited files available in the newly edited repository. git status Step 6: Below command helps to add the uncommited files into the repository....

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...

How to call stored procedure using powershell scripting with try and catch

Hello Techie's I know you are not the powershell scripting pro but your manager has given you the task to call the stored procedure in sql database using the powershell scripting. Now you are wondering where to start and how to proceed, not to worry we got you covered. you might be wondering why powershell scripting, why not shellscripting? Techie's we all know that one of the advantages of the powershell is that it has the .NET stack. once we have the call stack, if we face any errors we know where the issue is coming from. Problem Statement: 1. you need to call the stored procedure present in sql database or MSaaS DB 2. you need to add TRY & CATCH in your powershell script to capture the Errors. 3. you need to write a logfile into the filesystem to check the log level info Prerequisties:   1. You must have windows powershell Installed in your machine 2. you must know the sql database instance name 3. you must know the sql dababase name 4. you must know the stored procedur...

Daily Usage Linux Commands

Hello Techie's, If you are working for the client whose operating system is linux, Then you are in the Right place.  Take a note of the below commands and use it when the time comes and impress your colleague and Manager. 1. How to List specific lines from the file contains large Data ? If a file contains many lines and If you want to display lines from 800 to 900, you can use the above command. we can adjust the values which we are giving with head and tail commands based on our requirement. Command: cat filename | head -900 | tail -100 Output: 2. How to Perform HouseKeeping in the linux server ?  If your manager gives you task to Delete the unwanted files present in the disk. As a first Step you need to check if any of the filesystem disk used percent is exceeding 85%, then you need to navigate into that filesystem and find large files present in the folders. In the example command, I have listed top 20 large files present in the vagrant filesystem, If you want just top...