...how exactly can one create a "job" in SQL Server 2005 Express?
Is it possible?
-- Mark Kamoski
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.