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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 checkingfor success/failue on the Maintenance plan

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts
Posted - 2007-07-15 : 05:28:08
how can i check using a Select query
if a certin Maintenance plan had succeded if failed
withought the need to to connect to the server and check it

thnajs ibn advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-07-15 : 20:45:54
QUERY msdb..sysjobhistory.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts
Posted - 2007-07-16 : 02:00:30
thnaks
1 more question :
how can i get the description for an error wuth given sql_message_id ?
i found that master.dbo.sysmessages give somr of them but not all
on a maintainance failure with error 22029
couldnt be find on that table - any idea where?
thnaks i nadvance
peleg
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-07-16 : 22:34:33
Eusure the string for the target folder (the folder specified to store the database backup, or the one used for the transaction log backup or the one used for reports) in a maintenance plan doesn't contain "-S". For example, the directory path "C:\Db-Save" contains an "-S" string.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts
Posted - 2007-07-17 : 02:12:02
didnt understand u can u explain again please?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-07-17 : 13:19:07
Check knowledge base article 'Maintenance job fails on named instances of SQL Server 2000 with Error 22029' for details.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts
Posted - 2007-07-18 : 01:58:06
hi rmiao
the main idea of my original Question wasdnt to know the specific problem of the error
but rather to check the get a description of the problem (the example of error 22029 was just to show that i cant find the description for this error in the master.dbo.sysmessages )

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-07-18 : 12:01:01
Sysmessages table only stores sql engine related messages by default.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts
Posted - 2007-07-18 : 15:57:32
so from where does the erro message that i get?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-07-18 : 17:37:58
May from mdac.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts
Posted - 2007-07-18 : 17:51:18
mdac?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-07-18 : 18:26:12
Microsoft data connection components, odbc and ole db are part of mdac.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts
Posted - 2007-07-19 : 01:32:51
but i dont use them when the maintainance plan runs
so why should i check there errrors?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-07-19 : 10:57:49
Sql uses them since sql runs maintenance job with .exe program as I know.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site