I am writing an application which needs to obtain data from a Stored Procedure. The SPROC is in the MSDB database. I've attached the code example below. There are no parameters. When I run the code I get an error saying the stored procedure does not exist. I added a grid and went through the wizard to create the connection to the dbase. I am not receiving an error but there is no data in my grid. In the dbase I run EXEC uspGetJobInfo and data is returned but the data does not appear in in my .NET code.
SqlConnection cn = new SqlConnection(source);
SqlDataAdapter da = new SqlDataAdapter("uspGetJobInfo", cn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet DS = new DataSet();