No MOSS is not a replacement for SQL Server. MOSS requires SQL Server to function.
Yes MOSS comes with SQL Server 2005 Express Edition. You can download SQL Express edition for free from the Microsoft Website as a separate download.
Jobs to not work within the SQL Agent, as the Express edition of SQL Server 2005 does not include the SQL Agent.