How to run multiple SQLagent jobs at the same time


The answer to this question is very simple. I guess that most of you already know how to do it, but for those of you that don’t know it I decide to write this post.

The first thing is to open the SQL management studio, then connect to the SQL server where your jobs are located. The next step is to open the job activity monitor located under SQL Server Agent, then select the jobs you want to run, right click (A menu will be shown). From the menu select the option “Start Jobs” and Voila.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s