InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 05:56:38 GMT20http://www.sqlservercentral.com/Forums/Topic1190969-2905-1.aspxThanks Richar. I'll try it.Tue, 03 Jan 2012 10:07:42 GMTmario.granzellahttp://www.sqlservercentral.com/Forums/Topic1190969-2905-1.aspxBy default the output in SQL Server Agent goes to the msdb.dbo.sysjobhistory table (that's what you see when you ask to view history from the job). To get the output somewhere else, there are a number of possibilities, for example you could do this:$server = new-object( 'Microsoft.SqlServer.Management.Smo.Server' ) “(local)”foreach ($database in $server.databases) {$dbName = $database.NameWrite-Output "Database: $dbName" | Out-File c:\temp\temp.txt -append}Which will create and then append results to teh file c:\temp\temp.txt with the list of database names.Tue, 03 Jan 2012 10:05:16 GMTRichard Waymirehttp://www.sqlservercentral.com/Forums/Topic1190969-2905-1.aspxAgree and disagree: :-) :("repetitive tasks, or as in the case of CmdExec, any task that leaves the SQL Server environment is much simpler from the PowerShell subsystem.Disagree:Any repetitive SQL Server task can be easily done using t-sql inside SQL Server - that's what you have SQL Server Agent for!Agree:Tasks that leave the SQL Server environment - here PowerShell might be worth exploring.Tue, 03 Jan 2012 09:19:30 GMTpkrudyszhttp://www.sqlservercentral.com/Forums/Topic1190969-2905-1.aspxHi Richard, I'm new with PowerShell. I'm doing some test and I have a question about the step 2 of this job. Where is the output of the PowerShell script? Best regards and happy new year!MARIOThu, 29 Dec 2011 07:25:02 GMTmario.granzellahttp://www.sqlservercentral.com/Forums/Topic1190969-2905-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72459/">Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent</A>[/B]Sat, 15 Oct 2011 15:07:11 GMTRichard Waymire