Why can't I create a simple SQL Agent Job or find correct syntax?

This works perfectly in a SSMS 2008 query window:

use [HSS Maintenance]

exec HSS_Guest.[olap storedprocedure]
exec HSS_Guest.[MAKE OLAP_CUBE]

But when I build an Agent Job and then test by using "Start Job at Step..." it always fails.

I have tried Operating System (CmdExec) "Type" as well as T-SQL and even SSAS I believe.

Am I having a Syntax issue or not using the correct "Type"?

开发者_如何学JAVAUsing full rights on an Enterprise edition & Server 2008.

I have Googled this to death and do not believe that I can't just build this simply via the GUI.

Please show me how dumb I am!

Note - I have tried to generate the Script from the Job window and get an error that "There is no Action to be Scripted"

---

Edit the SQL Server Agent job that contains the step that has the SQL code you posted. Remove the "use [HSS Maintenance]" line and instead use the drop down menu on the step to choose this database.