Skip to Content
0
Apr 13, 2018 at 01:37 PM

Mass convert job status to unknown

130 Views Last edit Apr 13, 2018 at 02:17 PM 3 rev

Hi All

CPS build is M33.120-83827,

We have more than 70K+ jobs in status canceling, we need to set the status to unknown.

I'm looking for a query or script to do the conversion.

I need to use Job.Status , Job.JobDefinition and Job.Queue as the the condition in where clause.

Please provide the exact SQL query or script or any other method to get rid of changing each job status to unknown.

Help is very much appreciated

Thanks

Maddy.