使用Powershell查询U-SQL [英] Query U-SQL with Powershell

问题描述

Hi,

在我们的蔚蓝环境中，我们有99个U-SQL作业，并且遇到了一些常见的问题，其中有些作业没有自动运行.

In our azure environment we have 99 U-SQL jobs, and we run into a frequent problem where some of the jobs are not running automatically.

我可以使用什么命令来检查根本没有运行的作业.

What command could I use to check for jobs that have not run at all.

 我知道您可以运行" Get-AdlJob -Account *********  $ d-结果成功后提交-检查成功/失败的工作，但不检查尚未运行的工作 完全没有.

 I know you can run "Get-AdlJob -Account *********  -SubmittedAfter $d -result succeeded" to check for succeeded/ failed jobs, but wan't to check for ones that have not run at all.

将结果设置为无"；似乎也不起作用.

Setting the result to "none" doesn't appear to work either.

谢谢

J

推荐答案

您好，

Hello,

You can run the following cmdlet to know the last execution date and status of each one of your runbooks.

https://docs.microsoft.com/zh-cn/powershell/module/azurerm.automation/get-azurermautomationjoboutputrecor

https://docs.microsoft.com/en-us/powershell/module/azurerm.automation/get-azurermautomationjoboutputrecord?view=azurermps-6.10.0

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

这篇关于使用Powershell查询U-SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！