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 |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2003-08-22 : 11:51:28
|
| Hi everyoneI want to use SQL server Agent to create a job that can run a bat or cmd to monitor if the oracle database is up. the cmd is: sqlplus uid/pwd@databasebut I don't how SQL server job report failure or success, if it fails I want it sends pager to me. Thanks for your help!!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-22 : 12:29:14
|
| Just use the notifications tab on the job to send a page to you.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-22 : 12:31:59
|
| I should mention that in order to run that command that you are going to have to install SQL Plus on your SQL Server database server. You might want to consider a different way of doing this. Windows servers come with a Task Scheduler which is very similar to SQL Server Agent. You should run this command on a non-SQL Server server that has the Oracle tools on it and schedule the command using Task Scheduler.Tara |
|
|
|
|
|
|
SQL server Agent Job