This question is locked. New answers and comments are not allowed.
I have OpenAccess setup for a project of mine and I need to call one of the system level sprocs (sp_help_job) to get the date and time the job is schedule to run again. However, I do not see any way to create a domain method for this sproc. I have added the model for the MSDB database, and that works fine. But when I try to create the domain method for the sp_help_job sproc, it cannot retrieve the result shape.
I guess I could figure out what the shape looks like, build a tempoary table, then use it to generate the shape. Is that my only option? I am not sure I can do that because it would require that I modify the system level sproc.
In that case, I guess I could create a new sproc, create the shape, then somehow tell this domain method to use it?
What are my options here?
I guess I could figure out what the shape looks like, build a tempoary table, then use it to generate the shape. Is that my only option? I am not sure I can do that because it would require that I modify the system level sproc.
In that case, I guess I could create a new sproc, create the shape, then somehow tell this domain method to use it?
What are my options here?