Gurjobs (starting and stopping)

 Category : Gordon College\Banner

 Problem Description : 

Starting and stopping gurjobs

 Resolution : 

To verify if gurjobs is running go into PEBBLES, log in as oracle and type

ps -ef|grep gurjobs

If it looks like this, everything is running correctly. 

 $ ps -ef|grep gurjobs

banproc 3632 1 0 19:49:25 pts/0 0:00 gurjobs -o gurjobs_TEST_job1.lis

banproc 13910 1 0 03:18:27 ? 0:00 /gdn01/prodhome/general/exe/gurjobs -o gurjobs_PROD_job1.lis

banmgr 4845 20628 1 20:06:04 pts/0 0:00 grep gurjobs

If something is not running you will need to start it.

PROD su - banproc -c /gdn01/banproc/start_jobs you will then need to type in banproc's password (there is a space after the c)

TEST su^ -^ banproc^ -c /gdn01/banproc/start_test you will then need to type in banproc's password

DEVL su - banproc -c /gdn01/banproc/start_devl you will then need to type in banproc's password

To stop gurjobs, log into sql under the domain you want to stop.(make sure you are in the right domain before you run this. You don't want to stop gurjobs in PROD by accident.)

sqlplus system/password @gurstop

If you have more than one gurjobs running in a domain, you will need to run it mulitple times. 

Occasionally in TEST, the database will be in the middle of upgrades. Gurjobs will not run if the passwords have been changed for upgrades. If you must start it before the upgrades are finished, you will need to stop upgrading the system until they are finished.

log into putty as banmgr

cd /gdn00/scripts

There is a test_fix.sql which will change the passwords to what gurjobs will need. The test_unfix.sql will change the passwords to what the upgrades needs.

sqlplus system/password @test_unfix.sql 

*****GENERAL & SAISUSR need access to SFRPINI, GURJOBS  

 Revision Date : 2/10/2017