Showing posts with label email notification. Show all posts
Showing posts with label email notification. Show all posts
Tuesday, August 7, 2012

Email Notification ddl audit trigger

›
----------------------------------------------------------------------------------------------------------------------- connect sys as sy...

Email Notification for alter user

›
CREATE OR REPLACE TRIGGER dtr_userEvents BEFORE ALTER ON SCHEMA DECLARE   l_sqlText    ORA_NAME_LIST_T; BEGIN   IF ora_dict_obj_type ...
Friday, April 20, 2012

Oracle 10g Scheduler Job Email Notification Wrapped

›
------------------------job_email_notification.sql------------------------------ prompt Enter an outgoing e-mail SMTP server host define e...

Oracle 10g Scheduler Job Email Notification

›
----------------------------------------------------start job_notification.sql--------------------- -- Run this script as SYS with 2 para...
Monday, April 16, 2012

Oracle 11g Job Email Notification

›
exec DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('email_server','mail.kshitijdomain.com:25'); ----------------exec DBMS_SCHEDULER...
Saturday, March 24, 2012

Oracle 10g Scheduler Job Email Notification

›
1) connect sys as sysdba user and run two scripts for install and configure utl_mail package SQL> conn sys@apx1213 as sysdba Enter passwo...
Thursday, December 15, 2011

EMAIL NOTIFICATION changes in init.ora parameters

›
Auditing changes to init.ora parameters (via pfile or spfile) is an important DBA task. Sometimes, users which have “ alter system ” priv...
Thursday, August 25, 2011

Server Disk Space Notification

›
' Sample code for monitoring windows disk space ' Constants for drive types Const Unknown = 0 Const Removable = 1 Const Fi...

Low Disk Space Window Notification

›
Set wshShell = WScript.CreateObject( "WScript.Shell" ) strComputerName = wshShell.ExpandEnvironmentStrings( "%COMPUTERNAME%...
Friday, May 6, 2011

LD Billing Porcess Email Notification

›
CREATE OR REPLACE TRIGGER email_nsef_bill AFTER insert on TBLLOCKTABLE DECLARE b VARCHAR2(3) := UTL_TCP.CRLF; l_subject VARCHAR2(50) := ...
Wednesday, May 4, 2011

LD LOCKTABLE Email Notification

›
Select * From Tbllocktable Where Dcashbankfinancialentry Not Like ' '; ------------ CREATE OR REPLACE TRIGGER email_lock_table AFT...
Thursday, March 24, 2011

VBScript Email with authenticated SMTP User

›
Set wshShell = WScript.CreateObject( "WScript.Shell" ) strComputerName = wshShell.ExpandEnvironmentStrings( "%COMPUTERNAME%...
Tuesday, March 15, 2011

Email Notification for LDBO login

›
CREATE OR REPLACE TRIGGER LDBO_logon_notifications after logon on database DECLARE b VARCHAR2(3) := UTL_TCP.CRLF; l_subject VARCHAR2(40)...
Wednesday, September 1, 2010

Oracle User Login / Error Email Notification

›
connect sys as sysdba user and run two scripts for install and configure utl_mail package SQL> conn sys@orcl as sysdba Enter password: **...
Thursday, May 20, 2010

Oracle Export Backup Job Email Notification

›
---------------------------------------------Export.bat--------------------------- @ECHO off SETLOCAL IF [%1]==[] goto s_start ECH...

Oracler RMAN Job Email Notification

›
------------------------------------------------RMAN.bat-------------------- @ECHO off SETLOCAL IF [%1]==[] goto s_start ECHO GETDA...