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