Hi Pradeep,

I didn't see the script on the link you provided.

Thanks Pradeep

Thank you Alen

Hi Alen,

can you direct me to the link for the article?

Thanks for your reply,

-James

'Accept input parameters

Dim jobType

'first parameter

jobType= Wscript.Arguments.Item(0)

Set objMessage = CreateObject("CDO.Message")

objMessage.Subject = "Message Alert from SQL Server: " & jobType & " job...

I appreciate all the responses.

hello,

when I run the following powershell script, I get an error.

$destServer = 'VM-KMCSQL2005'

$destdb = 'BackupMonitoring'

#######################

function Get-SqlData

{

param([string]$serverName=$(throw 'serverName is required.'), [string]$databaseName=$(throw 'databaseName is required.'),

...