Thinking Out Loud

November 19, 2015

Windows Task Scheduler CMD

Filed under: Windows — mdinh @ 12:56 am

Don’t get me wrong. GUI can be terrific but it does have its place.

When the connection between you and the the target host are multiple servers across the continent, the latency will drive me crazy mad.

Hence, my exploration to learn more command line.

Enough of my rant, let’s demo.

Tested on Windows 7

C:\Users\dinh>ver

Microsoft Windows [Version 6.1.7601]

C:\Users\dinh>

List by Folders:

C:\Users\dinh>schtasks /query /fo table /nh

Folder: \
DropboxUpdateTaskUserS-1-5-21-992222644- 18-Nov-2015 11:07:00 P Ready
DropboxUpdateTaskUserS-1-5-21-992222644- 18-Nov-2015 8:07:00 PM Ready
G2MUpdateTask-S-1-5-21-992222644-2553030 18-Nov-2015 7:45:00 PM Ready
G2MUploadTask-S-1-5-21-992222644-2553030 18-Nov-2015 9:31:00 PM Ready
GoogleUpdateTaskUserS-1-5-21-992222644-2 19-Nov-2015 6:55:00 PM Ready
GoogleUpdateTaskUserS-1-5-21-992222644-2 18-Nov-2015 7:55:00 PM Ready
hpUtility.exe_{3FB4CD0B-D6EE-4B93-BD0E-C N/A                    Ready
Microsoft_Hardware_Launch_ipoint_exe     N/A                    Ready
Microsoft_Hardware_Launch_itype_exe      N/A                    Ready
Microsoft_Hardware_Launch_mousekeyboardc N/A                    Ready

Folder: \Microsoft
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows\Active Directory Rights Management Services Client
AD RMS Rights Policy Template Management Disabled
AD RMS Rights Policy Template Management N/A                    Ready

C:\Users\dinh>

List by TaskName:

C:\Users\dinh>schtasks /query /fo list

Folder: \
HostName:      CMWPHV1
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005Core
Next Run Time: 18-Nov-2015 11:07:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time: 18-Nov-2015 8:07:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \G2MUpdateTask-S-1-5-21-992222644-2553030573-2413354843-1005
Next Run Time: 18-Nov-2015 7:45:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \G2MUploadTask-S-1-5-21-992222644-2553030573-2413354843-1005
Next Run Time: 18-Nov-2015 9:31:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \GoogleUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005Core
Next Run Time: 19-Nov-2015 6:55:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \GoogleUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time: 18-Nov-2015 7:55:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \hpUtility.exe_{3FB4CD0B-D6EE-4B93-BD0E-C69652A66A6C}
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \Microsoft_Hardware_Launch_ipoint_exe
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft_Hardware_Launch_itype_exe
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft_Hardware_Launch_mousekeyboardcenter_exe
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

Folder: \Microsoft
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows\Active Directory Rights Management Services Client
HostName:      CMWPHV1
TaskName:      \Microsoft\Windows\Active Directory Rights Management Services Client\AD RMS Rights Policy Template Management (Autom
ated)
Next Run Time: Disabled
Status:
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft\Windows\Active Directory Rights Management Services Client\AD RMS Rights Policy Template Management (Autom
ated)
Next Run Time: Disabled
Status:
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft\Windows\Active Directory Rights Management Services Client\AD RMS Rights Policy Template Management (Manua
l)
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

C:\Users\dinh>

Search for TaskName:

C:\Users\dinh>schtasks /query /fo LIST |findstr /I dropbox

TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005Core
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA

List TaskName Summary:

C:\Users\dinh>schtasks /query /fo LIST /tn “\DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA”

Folder: \
HostName:      CMWPHV1
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time: 18-Nov-2015 8:07:00 PM
Status:        Ready
Logon Mode:    Interactive only

List TaskName Detail:

C:\Users\dinh>schtasks /query /fo LIST /v /tn “\DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA”

Folder: \
HostName:                             CMWPHV1
TaskName:                             \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time:                        18-Nov-2015 8:07:00 PM
Status:                               Ready
Logon Mode:                           Interactive only
Last Run Time:                        18-Nov-2015 7:07:00 PM
Last Result:                          0
Author:                               dinh
Task To Run:                          C:\Users\dinh\AppData\Local\Dropbox\Update\DropboxUpdate.exe /ua /installsource scheduler
Start In:                             N/A
Comment:                              Keeps your Dropbox software up to date. If this task is disabled or stopped, your Dropbox soft
ware will not be kept up to date, meaning security vulnerabilities that may arise cannot be fixed and features may not work. This ta
sk uninstalls itself when t
Scheduled Task State:                 Enabled
Idle Time:                            Disabled
Power Management:
Run As User:                          dinh
Delete Task If Not Rescheduled:       Enabled
Stop Task If Runs X Hours and X Mins: Disabled
Schedule:                             Scheduling data is not available in this format.
Schedule Type:                        Daily
Start Time:                           11:07:00 PM
Start Date:                           17-Jul-2015
End Date:                             N/A
Days:                                 Every 1 day(s)
Months:                               N/A
Repeat: Every:                        1 Hour(s), 0 Minute(s)
Repeat: Until: Time:                  None
Repeat: Until: Duration:              24 Hour(s), 0 Minute(s)
Repeat: Stop If Still Running:        Disabled

C:\Users\dinh>

If you really want to use GUI:

Launch GUI Task Scheduler:

C:\Users\dinh>control schedtasks

Reference: Schtasks

November 18, 2015

Extent Allocation

Filed under: 11g,ASM,oracle,performance — mdinh @ 11:43 pm

Some references on extents dealing with extent trimming, initial extent for parallel load, tablespace fragmentation, etc…

ASM AU Size And LMT AUTOALLOCATE
http://oracle-randolf.blogspot.com/2013/04/asm-au-size-and-lmt-autoallocate.html

Parallel Load: Uniform or AutoAllocate extents?
https://blogs.oracle.com/datawarehousing/entry/parallel_load_uniform_or_autoallocate

Tom Kyte covers this problem in great details in his post Loading and Extents
http://www.oracle.com/technetwork/issue-archive/2007/07-may/o37asktom-101781.html

System Managed Extent Size – 11g Improvements
https://antognini.ch/2009/08/system-managed-extent-size-11g-improvements/

PX and system allocation
https://jonathanlewis.wordpress.com/2012/06/14/px-and-system-allocation/

Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to 11.2.0.2 or Later (Doc ID 1295484.1)

Bug 19912552 : PARTITIONED INDEXES CREATED WITH 8M INITIAL EXTENT WHEN _INDEX_PARTITION_LARGE

Segments of type INDEX PARTITION or INDEX SUBPARTITION will be created with 8M initial extent in version 12.1.0.2, instead of 64K in earlier versions.
Global indexes or indexes on non partitioned tables still have 64K.

Blog at WordPress.com.