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.