Thanks Brian for the suggestions

I don't know the details what the programmers are doing but when I suggested the Print and Select option, they are aware of that but said...

Your concerns are noted and also share them.  However this is a test environment so not overly concerned.  From my searching around, that seems to be the only way to...

Since I'm not getting much for suggestions on this topic, is there another source or forum that might be able to assist?

Thanks!

Did some more looking into this job.  The agent job (syspolicy_purge) cleans up the history of the system policies that were run.  The history is stored in the msdb.dbo table. ...

Nevermind.  Co-worker, who was also working on this, had the "Include step output in history" checked for that step.  Now if we can determine if this task is really doing...

Thanks Sue for the suggestion.

I did a search on the server for SQLPS.  The only location where there is a SQLPS folder is at  C:\Program Files (x86)\Microsoft SQL Server\140\Tools\PowerShell\Modules.  Checking...

That example looks like the step is calling a specific .ps1 script.  Looking at the 3rd step, it doesn't appear to be like that:

I'm not sure...

• This reply was modified 5 years ago by  NotBob.

Appears it already is...