How to overcome this type tasks

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	@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

@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

0	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 Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

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

Latest Posts