Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Richard Waymire » Stairway to SQL Server Agent - Level 8: Using...

Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent

Rate Topic

Display Mode

Topic Options

Author

Message

Richard Waymire

Posted Saturday, October 15, 2011 3:07 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

Comments posted to this topic are about the item Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent

Post #1190969

mario.granzella

Posted Thursday, December 29, 2011 7:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:58 PM
Points: 5, Visits: 68

Hi 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!

MARIO

Post #1227778

pkrudysz

Posted Tuesday, January 03, 2012 9:19 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 24, 2013 1:32 AM
Points: 48, Visits: 258

Agree and disagree: Smile

"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.

Post #1229350

Richard Waymire

Posted Tuesday, January 03, 2012 10:05 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

By 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.Name
Write-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.

Post #1229406

mario.granzella

Posted Tuesday, January 03, 2012 10:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:58 PM
Points: 5, Visits: 68

Thanks Richar. I'll try it.

Post #1229409

« Prev Topic | Next Topic »

Permissions