Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
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 => 'email@example.com', recipients => 'firstname.lastname@example.org', subject => 'AGENT_USER Account is LOCKED', message => message_v ); end; /
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.