Loading in 5 sec....

Website to collect cell numbersPowerPoint Presentation

Website to collect cell numbers

- 73 Views
- Uploaded on

Download Presentation
## PowerPoint Slideshow about ' Website to collect cell numbers' - aiko-mathews

**An Image/Link below is provided (as is) to download presentation**

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

cell number data

snzengung3|7062479999|tmobile|

vravleker3|4782979999|verizon|

adoshi31|8656849999|verizon|

er46|4044019999|att|

kg65|6784779999|att|

gth772r|3166809999|verizon|

cpettiford3|2299449999|att|

canderson34|6788829999|att|

numapathy3|3233629999|att|

hdo7|6783659999|tmobile|

ccamacho3|9544259999|att|

pvanegas3|4046459999|tmobile|

mnourbakhsh3|6787829999|att|

SQL to select overdue items

set heading off

set pagesize 400

set linesize 200

set feedback off

spool text.lst

select circ_transactions.patron_id || '|' || bib_text.title || '|' from circ_transactions, bib_text, bib_mfhd, mfhd_item

where circ_transactions.item_id = mfhd_item.item_id and

mfhd_item.mfhd_id = bib_mfhd.mfhd_id and

bib_mfhd.bib_id = bib_text.bib_id and

circ_transactions.current_due_date < sysdate and

(circ_transactions.CIRC_POLICY_MATRIX_ID = '776' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '672' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '205' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '204' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '63' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '983' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '774' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '614' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '156' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '984' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '775' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '173' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '172' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '813' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '221' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '220' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '809' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '237' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '236' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '252' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '251' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '268' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '267' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '313' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '312' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '985' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '776' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '329' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '328' or

circ_transactions.CIRC_POLICY_MATRIX_ID = '810');

/

exit

Items overdue

58238|Calculator

192408|Headphones w/ mic

195984|Design drawing / Francis D.K. Ching with Steven P. Juroszek.

196850|History of urban form, prehistory to the Renaissance [by] A. E. J. Morris.

20862|Laptop

215063|Projector Screen

215063|Projector

215416|Peripheral Cable

215934|Projector

217183|Netbook

31423|Mon oncled'Amerique [videorecording] / produit par Philippe Dussart ; SceÌnario : Jean Gruault ; d'apres les travaux de Henri Laborit ; un film d'Ala

in Resnais.

69358|Fargo (DVD)

echo "Please return 'Calculator' to the Library Service Desk or call 404-894-4500 for renewal info." > text.msg

cat text.msg | mailx -r "[email protected]" [email protected]

echo "Please return 'Laptop' to the Library Service Desk or call 404-894-4500 for renewal info." > text.msg

cat text.msg | mailx -r "[email protected]" [email protected]

echo "Please return 'Netbook' to the Library Service Desk or call 404-894-4500 for renewal info." > text.msg

cat text.msg | mailx -r "[email protected]" [email protected]

echo "Please return ‘Fargo (DVD)' to the Library Service Desk or call 404-894-4500 for renewal info." > text.msg

cat text.msg | mailx -r "[email protected]" [email protected]

Cronjob runs every 30 minutes

0 4 * * 1-5 /gil/bin/GE-block gtechdb -o7 -iIID

15 4 * * 1-5 /export/home/voyager/runuserupdate

15 4 * * 6 /export/home/voyager/runuserupdate2

0,30 * * * 0-6 /export/home/voyager/textmessage/runtext

55 6 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j1

57 6 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j2

59 6 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j3

00 7 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j4

02 7 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j5

05 7 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j6

08 7 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j7

10 7 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j8

14 7 * * 1-5 /m1/voyager/gtechdb/sbin/Pcircjob -j24

17 7 * * 1-5 /export/home/voyager/holdexp

36 23 * * 1-5 /export/home/voyager/UB_scripts/cleanup.ksh

18 7 * * 1-5 /export/home/voyager/finfeeprint

19 7 * * 1-5 /export/home/voyager/rcovrprint

20 7 * * 1-5 /export/home/voyager/runprint

Download Presentation

Connecting to Server..