Query on Task Scheduler

Rising Flight 4,596

Hi All

i have an Azure VM which is running on Windows Server 2012R2. Under Task Scheduler it has many folders and every folder has tasks i.e many PowerShell scripts are running. Many are scheduled and running daily. few are disabled. I want to export all the tasks which are scheduled and running also when was it last ran. How do i export this information. I want to upgrade this VM to Windows Server 2019 and after upgrade i can validate these scheduled scripts are running fine or not. Almost i have 100 tasks and i dont know which are running. it is hard to go to each folder and check Experts guide me.

Accepted answer

MotoX80 33,916 Reputation points

2023-09-09T14:17:36.6233333+00:00
This script will export the data to a csv. Just add in any more fields that you want to save.

$data = @() foreach ( $task in (Get-ScheduledTask)) { $taskinfo = Get-ScheduledTaskInfo $task $data += [PSCustomObject]@{ Name = $task.TaskName Path = $task.TaskPath Enabled = $task.Settings.Enabled LastRun = $taskinfo.LastRunTime NextRun = $taskinfo.NextRunTime } } $data | Export-Csv c:\temp\tasks.csv -NoTypeInformation
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Rising Flight 4,596 Reputation points

2023-09-11T11:54:24.2166667+00:00

How to know last run job was successful or not.
Please sign in to rate this answer.
Rich Matheisen 46,796 Reputation points

2023-09-11T15:17:39.7166667+00:00

You'd have to enable the task history (it's disabled by default).

https://technicalmates.com/how-to-enable-task-scheduler-history-on-windows-11/

Once that's done you'll have to get the information from the event log: https://stackoverflow.com/questions/58012201/get-scheduled-task-to-see-history-for-more-than-last-run

MotoX80 33,916 Reputation points

2023-09-11T23:13:59.5333333+00:00

Analyze the $task and $Taskinfo variables and pull off the fields that you want.

$data = @() foreach ( $task in (Get-ScheduledTask)) { $taskinfo = Get-ScheduledTaskInfo $task $data += [PSCustomObject]@{ Name = $task.taskname Path = $task.TaskPath Enabled = $task.Settings.Enabled LastRun = $taskinfo.LastRunTime NextRun = $taskinfo.NextRunTime LastTaskResult = $taskinfo.LastTaskResult } } $data | Export-Csv c:\temp\tasks.csv -NoTypeInformation

Run the script in Powershell_ISE. That will populate those 2 variables with the data from the last task that you can then review.

$task | format-list -property * $taskinfo | format-list -property *
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Query on Task Scheduler

1 additional answer

Your answer