个人简介
白天和黑夜只交替没交换无法想像对方的世界
文章分类
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： python/ruby
2011-08-31 18:54:01
- #!/usr/bin/python
- #coding=gbk
- #2011-08-12
- import os
- import sys
- import smtplib
- import pickle
- import mimetypes
- from email.mimetext import mimetext
- from email.mimeimage import mimeimage
- from email.mimemultipart import mimemultipart
- smtp_server='localhost'
- #email_user='root'
- #email_passwd=''
- email_subject='dg01.com.cn awr report'
- from_user='root@dg01.com.cn'
- to_users=['vcdog@126.com','kevin@hotmail.com']
- def createawr():
- pipe = os.popen(' su - oracle -c "/u01/oracle/product/10.2.0/db_1/bin/sqlplus /nolog @awrrpt.sql"')
- print 'create awr report is ok!'
- def mysendmail(fromaddr,toaddrs,subject):
- commaspace=','
- msg = mimemultipart()
- msg['from'] = fromaddr
- msg['to'] = commaspace.join(toaddrs)
- msg['subject'] = subject
- txt = mimetext("172.21.1.30 awr report, the report be send at 9 am every day ")
- msg.attach(txt)
- filename = r'/home/oracle/awr.html'
- ctype, encoding = mimetypes.guess_type(filename)
- if ctype is none or encoding is not none:
- ctype = 'application/octet-stream'
- maintype, subtype = ctype.split('/', 1)
- att = mimeimage((lambda f: (f.read(), f.close()))(open(filename, 'rb'))[0], _subtype = subtype)
- att.add_header('content-disposition', 'attachment', filename = filename)
- msg.attach(att)
- server=smtplib.smtp(smtp_server)
- #server.login(email_user,email_passwd)
- server.sendmail(fromaddr,toaddrs,msg.as_string())
- server.quit()
- if __name__=='__main__':
- createawr()
- mysendmail(from_user, to_users, email_subject)
- print 'send successful'
给主人留下些什么吧！~~