Windows Task Scheduler; Inter dependent tasks; Custom filter

 <QueryList>

<Query Id="0" Path="Microsoft-Windows-TaskScheduler/Operational"> 

<Select Path="Microsoft-Windows-TaskScheduler/Operational">*[EventData [@Name='TaskSuccessEvent'][Data[@Name='TaskName']='\TaskName']]</Select> 

</Query>

</QueryList>

http://woshub.com/schedule-task-to-start-when-another-task-finishes/

Source:

Triggers 2nd Job:

Steps to schedule the trigger:

Start MySQL DB on Linux;

 Start MySQL :

• cd to the bin directory and run the mysqld program.

Stop MySQL :

• cd to the bin directory(/home/vijay/mysql-8.0.20-linux-glibc2.12-i686) and run service mysqld stop

Check where mysql is installed on LINUX:

• whereis mysql

> whereis mysql > cd /usr/local/mysql > ls > cd bin > ls > ./mysqld start & > pwd > cd .. > cd support-files/ > ./mysql.server start &

Decode function in Oracle; Example

 https://www.techonthenet.com/oracle/functions/decode.php

Run Python file on Visual Studio Code; Python

 

Right click on the file & select "Run Python File in Terminal" 

Connecting to Oracle DB from Python;

Make you cx_Oracle is installed on the machine;

if not do

> pip install cx_Oracle on windows command if working on Windows machine

import cx_Oracle

conn=cx_Oracle.connect('username/password@host:post/ServiceName')

print (conn.version)

Group access to linux user;

Create linux user 

sudo useradd VJ_test_user

Set Password for the user created

sudo passwd VJ_test_user

> VJ@123

Create a group 

sudo groupadd VJ_test_group

Add users to a group

sudo usermod -a -G VJ_test_group VJ_test_user

sudo usermod -a -G VJ_test_group VJapp

Give group access to the directory

chgrp -R VJ_test_group /home/VJ_test_user

Grant group access 

chmod g+rwX /home/VJ_test_user -R

Change owner of directory:

Change owner and group of directory- 

> chown -r username:groupname <Directory_Location>

Search text in Oracle DB; Returns all types of Oracle function where this text appears;

Select * from ALL_SOURCE  where TEXT LIKE '%Approval%'   

or 

Select * from dba_source where upper(text) like '%ENTER THE TEXT YOU WANT TO SEARCH HERE%'