Administrator

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

You can combine the steps into one job. Go into each job's steps and copy the information into one job.

rajesh.gandhi SSC Rookie Points: 33 More actions · Answer 2

Each job is running in different DB. How I'll define the DB?

SanjayAttray SSChampion Points: 13157 More actions · Answer 3

select database name from the drop down list in each job step or use

use Databasename

Go

in each step.

SQL DBA.

Jo Pattyn SSC-Dedicated Points: 32348 More actions · Answer 4

or you could use a script that uses

the stored procedure sp_start_job

if there are no dependencies.

rajesh.gandhi SSC Rookie Points: 33 More actions · Answer 5

SSC Rookie

Points: 33

March 18, 2008 at 11:52 am

thanks,

It worked.