Works great….thx
Brian
From: David Ramírez Reyes [mailto:dramirezr@xxxxxxxxx]
Sent: Friday, May 22, 2015 12:14 PM
To: Zelli, Brian
Cc: JBECKSTROM@xxxxxxxxx; oracle-l (oracle-l@xxxxxxxxxxxxx)
Subject: Re: notification from windows
You need to save it with a .vbs extension and just execute it.
I have it scheduled on the Windows scheduler (the first is the bat file that
generates the txt that is attached to the email).
[Inline images 1]
Also check that you can access the web services from the machine you're
executing the file.
David Ramírez Reyes
Profesión: Padre de Familia
On 22 May 2015 at 10:48, Zelli, Brian
<Brian.Zelli@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>> wrote:
Do I save this as a .bat file? I did find something like this from googling
but that didn’t work. After I made some changes with the FROM and TO and the
smtp, this didn’t work either. Or do I save it as something else and run it
differently?
Brian
From: David Ramírez Reyes
[mailto:dramirezr@xxxxxxxxx<mailto:dramirezr@xxxxxxxxx>]
Sent: Friday, May 22, 2015 11:08 AM
To: JBECKSTROM@xxxxxxxxx<mailto:JBECKSTROM@xxxxxxxxx>
Cc: oracle-l (oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>); Zelli,
Brian
Subject: Re: notification from windows
I have a job that checks the result of the last 3 full backups everyday, puts
it on a txt file and sends it by email, you can use something like this on vbs
file (does not require any installation):
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim fso, f
Set fso = CreateObject("Scripting.FileSystemObject")
'Open the file for reading
Set f = fso.OpenTextFile("D:\Alarms\MN3P\output1.txt", ForReading)
'The ReadAll method reads the entire file into the variable BodyText
BodyText = f.ReadAll
'Close the file
f.Close
Set f = Nothing
Set fso = Nothing
Set objEmail = CreateObject("CDO.Message")
objEmail.From = "mesdbas@xxxxxxxx<mailto:mesdbas@xxxxxxxx>"
objEmail.To = "mesdbas@xxxxxxxx<mailto:mesdbas@xxxxxxxx>"
objEmail.Subject = "MES MONT3 DAILY BACKUP REPORT"
objEmail.Textbody = BodyText
objEmail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing";) = 2
objEmail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver";) =
"smtp.xxxx.com<http://smtp.xxxx.com>"
objEmail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25
objEmail.Configuration.Fields.Update
objEmail.Send
David Ramírez Reyes
Profesión: Padre de Familia
On 22 May 2015 at 08:33, Jeffrey Beckstrom
<JBECKSTROM@xxxxxxxxx<mailto:JBECKSTROM@xxxxxxxxx>> wrote:
I use Blat to send smtp email on Windows.
I am running a small batch script from windows to check if the instance is up"Zelli, Brian"
<Brian.Zelli@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>> 5/22/15
9:10 AM >>>