プロジェクト

全般

プロフィール

操作問い合わせ #3224 » SQLite_command.txt

匿名ユーザー, 2019/10/18 18:03

 
[jobarranger]$ date
2019?N 10?? 18?? ???j?? 17:29:51 JST
[jobarranger]$ cd /var/lib/jobarranger/
[jobarranger]$ ls -ltr
???v 8172
-rw-r--r-- 1 root root 3196928 10?? 18 09:00 jobarg_agentd.db.backup
-rw-r--r-- 1 root root 2692096 10?? 18 14:47 jobarg_agentd.db
drwxr-xr-x 2 zabbix zabbix 20480 10?? 18 14:47 tmp
-rw-rw-r-- 1 root root 2437224 10?? 18 14:47 jobarg_agentd.db.jajournal
[jobarranger]$ sqlite3 jobarg_agentd.db
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from jobs where jobid = 2900506;
2900506|1|20190327180711082|0|command|{ }|echo Released|{ }|0|3|21407|1571377655|1571377655||Released
||0|0|JP-SVC-ShellUser|
sqlite>
[jobarranger]$
(2-2/7)