Solved

Scheduling Jobs for Execution:

Posted on 2016-11-25
4
15 Views
Last Modified: 2016-11-25
Hi experts

i am reading about Scheduling Jobs for Execution:
what's the mean?, can you give me an example?
.One job can have multiple schedules
.Multiple jobs can share one schedule
0
Comment
Question by:enrique_aeo
  • 2
4 Comments
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 250 total points
ID: 41901906
That would be SQL Server Agent, where you can create 'jobs' to run whatever executible / SQL Script / SSIS Package you wish, and then set a schedule of when it should be executed.  The schedules can be saved and reused in different jobs.
0
 
LVL 24

Assisted Solution

by:Mohammed Khawaja
Mohammed Khawaja earned 250 total points
ID: 41901908
What you could do is schedule a job to run lets say on a daily basis and then have the task repeat every hour.

Multiple jobs share the same schedule if you configure them to start at the same time.
0
 

Author Comment

by:enrique_aeo
ID: 41901950
.Multiple jobs can share one schedule. it is OK

what's the mean?, can you give me an example?
.One job can have multiple schedules
0
 
LVL 24

Accepted Solution

by:
Mohammed Khawaja earned 250 total points
ID: 41901979
Here is an example for you.  Lets say you have SQL database where you want to backup the database once a day and the logs every 30 minutes so that your RPO is 30 minutes.

For the database backup, it is simple as you schedule it "scheduling tape of Recurring", frequency to daily, to recur every 1 day and daily frequency to once.
For the logs backups, you do exactly the same but under daily frequency, you choose the option "occurs every" and set it to 30 minutes.
recurring.jpq.png
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now