I have a sql agent job that runs Powershell as its first step (there are 3 steps in total).
I have set this step to have 2 retries, with a 3 minute retry interval. When I look into the job history, the step_1 states that it is still running, and also that it has completed. It has done this for every time that it has run (at least the last year). Am I missing something from my powershell? Or is this something to do with sql agent itself?
Details of querying the
sysjobhistory table (Pipe seperated):
Step_name|step_id|run_date|run_time|run_duration|run_status (Job outcome)|0|2014/02/12|01:20:00|5|Succeded Record volume space to file|1|2014/02/12|01:20:00|2|In Progress Record volume space to file|1|2014/02/12|01:20:00|2|Succeded Load Volume Space|2|2014/02/12|01:20:02|1|Succeded Record database data file space|3|2014/02/12|01:20:03|2|Succeded
Step 1 runs the following Powershell:
gwmi win32_volume | select name, capacity, freespace | Export-Csv c:\temp.tmp