How can I run a report from a scheduled task or custom command?

Question

I have an “ADP Sync” scheduled task that modifies and creates users from a csv file. I also have reports that show new users created and management history for user modifications within the past 24 hours. The reports are scheduled to run 30 minutes after the ADP Sync schedule. This works if everything runs on schedule. However, if I manually run or if the scheduled task is delayed, I must also manually run the reports. How can I generate the reports as part of the ADP Sync scheduled task so that they only run after the ADP Sync task is complete?

Comments

I figured this out nevermind.

Answer 1

Hello,

To run a Report Scheduled Task in the ADP Sync Scheduled Task, you need to add the Run a program or PowerShell script action that will execute the below script to it. The action should be placed as the last one in the Scheduled Task. In the script, the $myReportScheduledTaskName variable specifies the name of the Report Scheduled Task to run. The script can be also used in Custom Commands and Business Rules.

$myReportScheduledTaskName = "Daily" # TODO: modify me

# Get the 'Report Schedule' container path
$reportScheduledTasksPath = $Context.GetWellKnownContainerPath("ReportSchedule")

# Bind to the Report Scheduled Task
$reportScheduledTasksPathObj = New-Object "Softerra.Adaxes.Adsi.AdsPath" $reportScheduledTasksPath
$myReportScheduledTaskAdsPath = $reportScheduledTasksPathObj.CreateChildPath("CN=$myReportScheduledTaskName")
$myReportScheduledTask = $Context.BindToObject($myReportScheduledTaskAdsPath)

# Run the Report Scheduled Task
$myReportScheduledTask.RunNow()