ehour

How to use: Set up the ADDM directory below the e-drive and put three files into it addm.cmd,ADDM. sql,myaddm. sql. The user needs to be given two permissions to connect the premises.Grant Select any dictionary to user,-----user for production database accountGrant Advisor to user,-------user for production database account1. File name:addm. Cmdcontent: cmd.exe/c sqlplus username/[email protected] @ADDM. sql2. File name: ADDM. sqlcontent:@@e:\ADDM\myaddm.sql 0 8@@e:\ADDM\myADDM. SQL 8 12@@e:\AD

Name:Addm. SQL Content: @ E: \ addm \ myaddm. SQL 0 8@ E: \ addm \ myaddm. SQL 8 12@ E: \ addm \ myaddm. SQL 12 14@ E: \ addm \ myaddm. SQL 14 18@ E: \ addm \ myaddm. SQL 18 24Exit 3. File Name:Myaddm. SQL Content: set echo off;set veri off;set feedback off;set termout on;set heading off;set linesize 300;var dbid number;var inst_num number;var bid number;var eid number;var bhour varchar2(10);var ehour varchar2(10);var task_name varchar2(40);begin:bh

the smtp server. login (username, password) # log on to smtp. sendmail (sender, receiver, message. as_string () # send smtp. quit () print ("SEND") failed t: print ("send failed ") #5. Configuration and execution While True: # configuration #__ time _____ ehour = 5 # scheduled hour emin = 21 # scheduled minute esec = 41 # scheduled second current_time = time. localtime (time. time () # current time date cur_time = time. strftime ('% H % m', time. loc

") 4. Configuration and execution While True: # configuration #__ time _____ ehour = 11 # scheduled hour emin = 49 # scheduled minute esec = 50 # scheduled second current_time = time. localtime (time. time () # current time date cur_time = time. strftime ('% H % m', time. localtime (time. time () # current time str #__ mysql _____ #__ email _____ sender = ''# sender email receiver = ['2017 @ qq.com '] # recipient email, username = ''# sender name pas

CREATE proc Sp_meetingcheck_test@serialno varchar (max) = ",----main file Serialno@title nvarchar (+) = ',--Meeting Theme@buser nvarchar (50) = "--File holderAsDECLARE @Result varchar (max)DECLARE @sdate datetimeDECLARE @edate datetimeDECLARE @stime datetimeDECLARE @etime datetimedeclare @shour nvarchar (50)declare @ehour nvarchar (50)DECLARE @sdate1 datetimeDECLARE @edate1 datetimeDECLARE @stime1 datetimeDECLARE @etime1 datetimedeclare @shour1 nvarch