[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

some clarification needed on sql2005 job scheduling

I have the job as below, it has job frequency once at  12:30 am, so when I set the end date, what will happen on my last day of job ?
schedule.jpg
0
motioneye
Asked:
motioneye
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
On 30th of April, the job would be run by 12:30 am ie., 00:30 am as the last run
0
 
motioneyeAuthor Commented:
Hi,
when we say it will stop at 30th-april, is that mean end at  30th-april 23:59:59 or 30th-april 00:00:00
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Or in other words, the job will be triggered last on 30th-april 00:00:30
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now