Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-25 : 11:10:52
|
Philip writes "Hi,
I have been tasked with developing a small app to allow application administrators to administer the scheduling of jobs that run for the applications in our bank. This is because the powers don't want to install SQL Server Enterprise Manager on 10 different workstations.
I have not had too many problems with the ap_addjob, deletejob, add_jobschedule stored procedures. I can even return some useful information about job schedules, such as name, enabled, id. However, I would also like to include in my listview (which I must admit looks remarkably similar to the one in Enterprise Manager!) the description of the job schedule... obviously it would be easier to users if they can see something like:
'Occurs every 1 week(s) on Sunday, at 12:30 AM.'
or even:
'Occurs every 1 month(s) on the Last Sunday of that month at 12:30 AM'
In SQL Server Enterprise manager this description seems to be provided automatically. So I had a look at the help for sp_help_jobschedule and it states in the Result Sets section that a column called 'schedule_description' is provided.
So I think, I just call sp_help_jobschedule from my visual basic app, and once of the columns will have the description (BTW this is NOT a vb question, try this from SQL Query Analyser!). Unfortunately this is not so, I can get all the other information that I want, but the description field just says:
'(Description not requested.)'
and the same applies when I run the stored proc in SQL Query Analyser.
Can you help? If I am unable to return this information from this field in the result set I am going to have to do it the hard way, building the string from analysis of all of the other fields returned in the result set, and this is something I want to avoid as it will take 10 times as long.
" |
|
|
|
|
|
|
|
Problem with sp_help_jobschedule