SQL Server Agent CmdExec Excel

[ehenry]

I am trying to make the SQL Server Agent open excel as one of my job steps. "c:\program files\microsoft office\office12\excel.exe" The job just runs endlessly and does not open excel. Any help on this would be appreciated.

 

[mrdenny]

This is because Excel is running under the context of the SQL Server, not your user account.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog