473,387 Members | 1,942 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How Do I Retrieve job Information that how many times it occurs in a week?

Hi,
I want to retrieve how many times a job runs each week.
I checked in sysschedules and syjobschedules tables under msdb database.
But I could not find a way to retreive information.

(Example: weekly jobs can run 5 days a week. I want to find in what are all the days this job runs and how many times. (i.e) If two times a day 10 times a week for this case)

I could manually do for each job seeing the properties of each. But there are more than 150 jobs And am given limited access time to the DB.

Pls do help me on this!!
Thanks in Advance!!
Feb 4 '12 #1
1 1520
shweta123
692 Expert 512MB
Hi,

Please refer this Link


Thanks,
Shweta
Feb 4 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Ian | last post by:
On the web site: (www.mvps.org/access/) I found a lovely piece of code that retrieves the operating systems name, build number, service pack etc. Is there something similar to retrieve information...
5
by: Roy Gourgi | last post by:
Hi, I am used to working in Visual FoxPro and I would like to be able to create a database and store and retrieve information from it. What is the simplest way to do it and what should I be...
1
by: Connull | last post by:
How do I retrieve the Customer Information and Serial Number used after my Application has been Installed (as per Visual Studio .NET splash screen)
0
by: Ruy Castelli | last post by:
Hello, I'm trying to collect information from a GridView. Basically, the user clicks on a buttonfield (which is a link button) and then I need to get the information displayed on the gridview...
0
by: zipzap | last post by:
<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:fp="http://www.w3.org/1999/XSL/Format" exclude-result-prefixes="fp"> ...
21
tpaine
by: tpaine | last post by:
Let me preface this by saying that this is most certainly not a code issue but a config issue. I have been able to implement the code fine on my live server, this problem only occurs on my localhost....
7
maxamis4
by: maxamis4 | last post by:
Hello, I am currious to know how I can extract information from outlook into access. So far I have this code which I am using to test, but I can' t find any other information on the net. All I...
2
by: James Wong | last post by:
Hi everybody, I would like to know how to retrieve information from AssemblyInfo.vb inside web service. I've tried many different ways including GetExecutingAssembly or similar method but all...
2
by: zek2005 | last post by:
Hi! I have a value loaded in a database as following: &lt;p&gt;&lt;strong&gt;test&lt;/strong&gt;&lt;/p&gt; &lt;p&gt;&lt;strong&gt;test 2&lt;/ strong&gt;&lt;em&gt;&lt;strong&gt;questions&lt;img alt=&quot;&quot;...
3
by: mistersulu | last post by:
Hi all: I'm using a wx.ListView object with a multi-threaded wxPython app. The list is dynamically generated and accessed across two or more threads. In spite of the fact that I have checks to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.