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 Administration (2000)
 help me in doing this

Author  Topic 

sharma
Starting Member

1 Post

Posted - 2005-08-03 : 13:08:47
i have a to make a job on another sql server from my local
server how to make it tell me the procedure
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-08-03 : 15:14:04
I don't understand the question. Could you explain in detail what you need?

Tara
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-08-03 : 22:41:01
check the following things before you create the job:

1. can you connect to the server from your local via Enterprise Manager (EM) or Query Analyzer (QA)?
2. do you have enough permission to create a job?

Answer to both questions must be yes

next, on creating the job itself, look for Jobs in Books OnLine (this came with your client tools upon installation), it's outlined there how to create jobs using EM and QA

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -