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
Wednesday, November 28, 2007
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)
@{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.
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.
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.
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/
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
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
rundll32.exe user32.dll,LockWorkStation
Subscribe to:
Posts (Atom)