How to overcome this type tasks

Posted by Jayakumars under Sql Server on 2/2/2017 | Points: 10 | Views : 364 | Status : [Member] [MVP] | Replies : 3
Hi

How to set this type jobs using Query with schedule timing in sql server only.
only Query no need design side.

I saw this command for automatically backup in stackoverflow url. But i need
how to generated this guid value with automatic schedule particular timing for automatic backup for ex this server i need daily 9.00 am raise this
how will do this any one guide me

60CD93F9-CFC2-4A84-8B06-3AD8DEADBEEF

this is command

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Backup 60CD93F9-CFC2-4A84-8B06-3AD8DEADBEEF -server DummyServer

Mark as Answer if its helpful to you


Responses

Posted by: Rajnilari2015 on: 2/3/2017 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
@Jayakumars Sir,
a) For scheduling (9AM), in the SQL Job , choose the "Schedule" option and in the Frequency section schedule the JOB timing.
b) 60CD93F9-CFC2-4A84-8B06-3AD8DEADBEEF - is the primary_id of the Primary database.

For more understanding : https://msdn.microsoft.com/en-us/library/bb283327.aspx

Hope that helps





Hope that helps.


--
Thanks & Regards,
RNA Team

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 2/4/2017 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi

I am setting Scheduled timing in design mode . But not running which i setting time in my job.
i try right click the job then start job then only run my job otherwise not running .
any way to solve this?


Mark as Answer if its helpful to you

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 2/23/2017 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Double check the following on Scheduler

1. Schedule is enabled or not?
2. set proper end date or select No End Date option
3. Set proper Frequency(Daily, Weekly or Monthly) for executing the job
4. what are the timings you want to run job


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response