[/quote]

Hi Mark,

One can schedule SQL Server job in Windows Task Schedule using OSQL or SQLCMD. This is an example of the content of the .bat batch file for one of my jobs that sends emails

osql -Sservername -UuserName -PPassword -dDatabaseName -Q"exec DbName.dbo.SPnamel" >"C:\LogName.txt" -n -m-1

One thing that I question is the line for specifying the profile name. While the rest of the scrip works well, sending an email returns an error aabout invalid profile nameas I expected, because the mail server name is not profile name unless the system administrator set up a few profiles with the names same as mail server names.

Yelena