—-Abrir Tienda
–select info02, * from sysconfig where id = ‘storeopen’
–update sysconfig
–set info01 = ’03:00:00′ —’05:00:00′
–where id = ‘storeopen’
—-Cerrar Tienda
–select info02, * from sysconfig where id = ‘storeclose’
–update sysconfig
–set info02 = ’15:00:00′ —’22:00:00′
–where id = ‘storeclose’
select getdate()
select progstarttim, eopstatus, acctstatus, currentdate, currptdate, progname from acctperiod with (nolock)
–>Revisar procesos pendientes
–declare @diaContable as date = ‘20201006’
–select ProgName, * from reportbatch where MonthOfYear = ‘‘ — and DayOfWeek = ‘‘ and
— lastrundate = DATEADD(day,-1,@diaContable)
—-validar cierre de caja general
–declare @date date=’20201006′
–SELECT * FROM STORE_FinalTenderTotals WHERE CAST(Date as date) = @Date
–select top 21 * from eodlog where logdate=’20201006’and progname=’WcfService.EODProcServices ‘order by autosequence desc
–>Revisar ejecución de job de cierre de tienda/hub
use SMSscheduler
select * from SMS_JOBS where JOB_NAME like ‘%eod%’
