Unanswered: refreshing the msdb..sysjobschedules table...
Hi there ... I need to check the next_run_date and next_run_time field of the sysjobschedules table from my C program, but it is not updated immediately after a job is run/created. How can I refresh the table before I access is so that I can get the latest value stored? Is there a stored proc or T-SQL statement I can issue to do this?
HOWPPP someone can help me out here .... thanks ... !!!
The correct date/time always appears in the Enterprise Manager's window, probably because it is accessed directly from the SQL-DMO object (right?) ... but I can't use SQL-DMO .... (not installed) .... :-(