1) How do I query a SQL executive scheduled task from VB 6.0 so that I
can read it's history, to tell if it worked ok. The problem I have is that
I have a scheduled task which copies a zip file of backups that have taken
place each night onto an arcserve fileserver. This is happening on 7
databases, so I want to write a VB program which interrogates all the
scheduled tasks to check their status. I need to read it's history, so
sometimes it ends with a process code 0 (success), but the actual copy job
did not work due to network problem etc.
2) How do I stop and start SQL server and SQL executive from VB. There
is a command line statement which does this (Something like net stop
sqlexecutive /u), but I want to also tell that the server has stopped, or
that the server has come back on-line again. I'd like to do this with an
API call, and not issuing the above as a dos shell command.
If you can help with any of the above, could you reply also to
as I very rarely have time to read this newsgroup, and I may miss a reply.
Regards,
Scot Brown