Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
declare crlf varchar2(2):= CHR( 13 ) || CHR( 10 ); message_v varchar2(32000); vJobNumber binary_integer; begin dbms_job.submit( job => vJobNumber, next_date => to_date('14:00','HH24:MI') interval => (trunc(sysdate) +30/1440),what =>' for i in (select user_id, account_status, lock_date from dba_users where username = 'AGENT_USER' and account_status = 'LOCKED') loop message_v := message_v || i.user_id || ' is in ' || i.account_status || ' status since ' || to_char(i.lock_date,'MM/DD/YYYY') || crlf; end loop; utl_mail.send ( sender => 'firstname.lastname@example.org', recipients => 'email@example.com', subject => 'AGENT_USER Account is LOCKED', message => message_v ); end; /
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!