Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

two jobs runnig at a time Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 6:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 10:47 AM
Points: 4, Visits: 16
hi in my environment one job is running at 9 pmc, i want to run the another job at same time 9 pm i want to run the two jobs at a time in sql server agent, is it will effect to any jobs, or is it going to any business impact. please let me know
Post #1442705
Posted Tuesday, April 16, 2013 6:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 5,227, Visits: 9,437
You can certainly run two jobs at the same time. Whether or not they have any impact on each other depends on what they do.

John
Post #1442712
Posted Tuesday, April 16, 2013 7:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 10:47 AM
Points: 4, Visits: 16
hi,
one job is trackwaitstatus for genereating report for the databases and one for ssis package job for trasfer the data from prod to uat
Post #1442733
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse