Wednesday, November 28, 2007

Set A Job To Run Every Hour on Top of The Hour

In sql*plus:
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,’myuser.myproc();',TRUNC(SYSDATE+(1/24), 'HH'),
'TRUNC(SYSDATE+(1/24),''HH'')');
END;

PRINT jobno; -- to display assigned job id to task

Tuesday, November 27, 2007

Install Oracle Supplied Packages

in sql*plus
@{ORACLE_HOME}\rdbms\admin\dbms****.sql (dbmsjob.sql)
@{ORACLE_HOME}\rdbms\admin\prvt****.plb (prvtjob.plb)

Sunday, November 25, 2007

Bypass Blue Screen and Reboot

HKEY_LOCAL_MACHINE\SYSTEM\
CurrentControlSet\Control\CrashControl\
AutoReboot

0 Do not restart automatically.
1 Restart automatically.

Force Program Exit

HKEY_CURRENT_USER\Control Panel\Desktop\AutoEndTasks

0 Processes do not end automatically. The system waits until the process ends, and, if the process takes more time than the value of the HungAppTimeout entry, the End Task dialog box appears, stating that the application cannot respond to the End Task request.

1 Processes end automatically.

Hung Application Time

Set HKEY_CURRENT_USER\Control Panel\Desktop\ HungAppTimeout to timeout in Milliseconds in decimal

Specifies how long the system waits for user processes to end after the user clicks the End Task command button in Task Manager or after the user has selected to restart or shutdown the system. If this threshold is exceeded, the End Task dialog box appears, stating that the process did not respond.

sshwindows sftp Change Default Home Directory

If home directory for user in /etc/passwd set to /home/..., it refer to C:\documents and settings\... folder on windows.

To access other drives or folders add /cygdrive/DRIVELETTER/ to beginning of the folder path like /cygdrive/e/download/

Disable Windows Shutdown in Logon Screen

1-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\Current Version\Winlogon
2-Add a value named "ShutdownWithoutLogon" of type "REG_SZ" and set it to "0".
Restart Windows

Friday, November 9, 2007

Hibernate and Lock Windows in command line

rundll32.exe powrprof.dll,SetSuspendState Hibernate

rundll32.exe user32.dll,LockWorkStation