@ECHO ON
rem cd /D %~dp0
cd D:\SoftWare\mysqlworkbench
mysql -uroot -psoft -h******* -P**** -N < D:\1.脚本\VTF\vtf.sql
pause
-- SELECT * FROM vtp.auto_init_log where SUBSTR(auto_start_time,1,8)= date_format(now(),'%Y%m%d') and group_id in (1,2) and task_type=1;
select '**********集中交易**********';
select '====当前交易日====';
select tradedate from vtp_1.tbl_current_tradedate where SUBSTR(tradedate,1,8)= date_format(now(),'%Y%m%d');
select '====初始化日期====';
select sys_init_date from vtp_1.tbl_current_tradedate where SUBSTR(sys_init_date,1,8)= date_format(now(),'%Y%m%d');
select '====撮合启动====';
select exists (SELECT 1 FROM vtp_1.startup_status where SUBSTR(time,1,10)= date_format(now(),'%Y-%m-%d'));
select ' ';
select ' ';
select '**********融资融券**********';
select '====当前交易日====';
select tradedate from vtp_2.tbl_current_tradedate where SUBSTR(tradedate,1,8)= date_format(now(),'%Y%m%d');
select '====初始化日期====';
select sys_init_date from vtp_2.tbl_current_tradedate where SUBSTR(sys_init_date,1,8)= date_format(now(),'%Y%m%d');
select '====撮合启动====';
select exists (SELECT 1 FROM vtp_2.startup_status where SUBSTR(time,1,10)= date_format(now(),'%Y-%m-%d'));