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)
 job creation

Author  Topic 

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-09 : 05:26:54
Hi

can we create same 2 job names for different databases
IN SQL SERVER AGENT JOBS
please suggest me

nr
SQLTeam MVY

12543 Posts

Posted - 2007-01-09 : 07:29:03
Not sure what you mean.
The agent conects to the server to run your command so you can run the same command on several databases within the same job.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -