JDBC Driver issue: jobs

Showing posts with label jobs. Show all posts

Friday, March 30, 2012

Jobs

I have created several jobs which contains several steps inside it. Now with the schedule it runs very frequently and more than 100 jobs are running almost simulteneously. so I want to limit the number of jobs running at a time say at a time I want to run 10 jobs after that other 10 set and s
How can I do it help me ou
Regards
SunilYou can adapt schedules, or you can create a wrapper job. This wrapper job
can start other jobs on each own step using the sp_start_job system SP.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Sunil" <anonymous@.discussions.microsoft.com> wrote in message
news:9250860D-15DE-408D-A5A8-3CA7FAD56CC4@.microsoft.com...
> I have created several jobs which contains several steps inside it. Now
with the schedule it runs very frequently and more than 100 jobs are running
almost simulteneously. so I want to limit the number of jobs running at a
time say at a time I want to run 10 jobs after that other 10 set and so
>
> How can I do it help me out
> Regards,
> Sunil

JOBS

Hi All,
I am currently running a job that backs up a database using
the following code
BACKUP DATABASE [Leads] TO DISK = N'\\mymachine\d$\backup\leads.bak' WITH INIT , NOUNLOAD ,
NAME = N'Leads backup2', SKIP , STATS = 10, noFORMAT
this most of the time works fine but every now and again it
complete's fine but keeps the database locked open, is
there any way to fix this'
Thanks PhilWhat exactly do you mean by "Locked Open"?
--
Andrew J. Kelly SQL MVP
"Phil" <harlequintp@.blazemail.com> wrote in message
news:051801c3fabf$38fedc30$a101280a@.phx.gbl...
> Hi All,
> I am currently running a job that backs up a database using
> the following code
> BACKUP DATABASE [Leads] TO DISK => N'\\mymachine\d$\backup\leads.bak' WITH INIT , NOUNLOAD ,
> NAME = N'Leads backup2', SKIP , STATS = 10, noFORMAT
> this most of the time works fine but every now and again it
> complete's fine but keeps the database locked open, is
> there any way to fix this'
> Thanks Phil|||Sorry I should of been a little clearer, what I mean is
although the job says that it has completed, if you look
at the locks section in the SQL Enterprise Window, you
can still see a lock on the database showing the code
featured below.
Thanks again for your help!
Phil
>--Original Message--
>What exactly do you mean by "Locked Open"?
>--
>Andrew J. Kelly SQL MVP
>
>"Phil" <harlequintp@.blazemail.com> wrote in message
>news:051801c3fabf$38fedc30$a101280a@.phx.gbl...
>> Hi All,
>> I am currently running a job that backs up a database
using
>> the following code
>> BACKUP DATABASE [Leads] TO DISK =>> N'\\mymachine\d$\backup\leads.bak' WITH INIT ,
NOUNLOAD ,
>> NAME = N'Leads backup2', SKIP , STATS = 10,
noFORMAT
>> this most of the time works fine but every now and
again it
>> complete's fine but keeps the database locked open, is
>> there any way to fix this'
>> Thanks Phil
>
>.
>|||You have to be even clear than that<g>. What type of lock does it have?
Are these locks causing problems? It is normal for any connection to a db
to have at least a shared lock on the db. You also have to refresh EM in
order for most of the windows to show up to date information.
--
Andrew J. Kelly SQL MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:0bd801c3fb1f$b4c51a40$a401280a@.phx.gbl...
> Sorry I should of been a little clearer, what I mean is
> although the job says that it has completed, if you look
> at the locks section in the SQL Enterprise Window, you
> can still see a lock on the database showing the code
> featured below.
> Thanks again for your help!
> Phil
> >--Original Message--
> >What exactly do you mean by "Locked Open"?
> >
> >--
> >Andrew J. Kelly SQL MVP
> >
> >
> >"Phil" <harlequintp@.blazemail.com> wrote in message
> >news:051801c3fabf$38fedc30$a101280a@.phx.gbl...
> >> Hi All,
> >>
> >> I am currently running a job that backs up a database
> using
> >> the following code
> >>
> >> BACKUP DATABASE [Leads] TO DISK => >> N'\\mymachine\d$\backup\leads.bak' WITH INIT ,
> NOUNLOAD ,
> >> NAME = N'Leads backup2', SKIP , STATS = 10,
> noFORMAT
> >>
> >> this most of the time works fine but every now and
> again it
> >> complete's fine but keeps the database locked open, is
> >> there any way to fix this'
> >>
> >> Thanks Phil
> >
> >
> >.
> >sql

Jobs

quote:

> I have created several jobs which contains several steps inside it. Now

with the schedule it runs very frequently and more than 100 jobs are running
almost simulteneously. so I want to limit the number of jobs running at a
time say at a time I want to run 10 jobs after that other 10 set and so

quote:

>
> How can I do it help me out
> Regards,
> Sunil

Jobs

Hi,
Using Enterprise Manager, when i create a job, The job properties dialog box
has Schedules tab. In Schedules tab I have option to create New Altert.
I am trying to undrestand why would i need to create an alert in Job
Schadules.
Any help would be apprecited,
AliHi,
By setting an alert on a job, you can send a Email / Pager message to get
the status of your job.
Thanks
Hari
MCDBA
"A.M" <IHateSpam@.sapm123.com> wrote in message
news:eZuJTct3DHA.4060@.TK2MSFTNGP11.phx.gbl...

quote:

> Hi,
> Using Enterprise Manager, when i create a job, The job properties dialog

box

quote:

> has Schedules tab. In Schedules tab I have option to create New Altert.
> I am trying to undrestand why would i need to create an alert in Job
> Schadules.
> Any help would be apprecited,
> Ali
>

|||Hi Ali,
Thank you for using MSDN Newsgroup!
I would like to follow up on this issue and see if you still have questions
about this issue. Should you have any questions, please feel free to post
here. Looking forward to your reply!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Jobs

Good morning,
What I can do to allow developers have access to view the jobs I created
with out giving them administrator permission?
Thanks.Hi
Doesn't member of db_owner fixed database role have an access to the jobs?
"Matthew Z" <MatthewZ@.discussions.microsoft.com> wrote in message
news:4315658A-3079-41F7-B8E9-45225924CDAF@.microsoft.com...
> Good morning,
> What I can do to allow developers have access to view the jobs I created
> with out giving them administrator permission?
> Thanks.|||Thans. but I don't want them to be a member of db_owner.
"Uri Dimant" wrote:

> Hi
> Doesn't member of db_owner fixed database role have an access to the job
s?
>
>
> "Matthew Z" <MatthewZ@.discussions.microsoft.com> wrote in message
> news:4315658A-3079-41F7-B8E9-45225924CDAF@.microsoft.com...
>
>|||There are no special roles for job management in 2000. There are in 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matthew Z" <MatthewZ@.discussions.microsoft.com> wrote in message
news:4315658A-3079-41F7-B8E9-45225924CDAF@.microsoft.com...
> Good morning,
> What I can do to allow developers have access to view the jobs I created
> with out giving them administrator permission?
> Thanks.|||There is a role in msdb called TargetserverRole, which allows members to vie
w
the jobs in EM.
Just keep in mind this is undocumented and subject to change. For instance,
permissions this role had were changed with SP3. So if you make use of it,
test in dev before slapping SP4 on in production (if/when it comes out).
I got above info from following discussion at sqlservercentral:
[url]http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=108953[
/url]
"Matthew Z" wrote:

> Good morning,
> What I can do to allow developers have access to view the jobs I created
> with out giving them administrator permission?
> Thanks.

JOBS

Thanks for the help on this, when you go to the Locks/Object
section of Enterprise Manager, and click the drop down you
see the (said database in there, when you look at the
process's on the left hand screen, you have a ProcessID of
15, locktype = DB, Mode = U, Status = Grant, Owner = Sess
when you click for the properties of the process id, you
get the backup statement previously discussed, even though
the job that run's the script has finished and completed
sucessesfully, I'm afriad I cant go into any more detail
than that.
Sorry, PhilDid you try refreshing the screen? You can right click on the node above
the locks and choose "Refresh". See if that helps. Also run cp_locks in QA
and see if thoe locks still show up.
Andrew J. Kelly SQL MVP
"Phil" <anonymous@.discussions.microsoft.com> wrote in message
news:168201c3fbb8$02a5a430$a101280a@.phx.gbl...
> Thanks for the help on this, when you go to the Locks/Object
> section of Enterprise Manager, and click the drop down you
> see the (said database in there, when you look at the
> process's on the left hand screen, you have a ProcessID of
> 15, locktype = DB, Mode = U, Status = Grant, Owner = Sess
> when you click for the properties of the process id, you
> get the backup statement previously discussed, even though
> the job that run's the script has finished and completed
> sucessesfully, I'm afriad I cant go into any more detail
> than that.
> Sorry, Phil

JOBS

Job to Backup Log when Full

We would like to be able to read the database name that triggered the alert
and have a job that backs up that log only. Where would I get that database
name? The alert has it, does it store it in a system table in msdb?
Thanks!
There is a group of Alert tokens that you can use...
For instance, you could create a job that has one step
Backup log [A-DBN] to disk = 'c:\[A-DBN].logbak'
When the job is called from an Alert, the token will be replaced (even in
the filename string... and the appropriate database log will be backed up...
But the job can not be run< except from an alert> , because that is the only
time the tokens will be replaced..
For a complete list of Alert tokens, go to Gert Drapers web site
http://www.sqldev.net/sqlagent/SQLAg...ns.htm#Example using TSQL
step
"Michelle" <michelle@.nospam.com> wrote in message
news:eDmu1PNIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We have several servers with dozens of databases on each one. We have
> elected to group our maintenance jobs so that all database backups are
> consolidated into 4 separate jobs (alphabetically). We would like to
backup
> a log using our standard practices if it gets full. We don't want to call
> the 'consolidated' job because if the db is the last alphabetically, it
will
> have to go through all of the preceeding dbs before it gets to that log.
By
> that time, I could have gotten up out of bed and backed up the log myself

> We would like to be able to read the database name that triggered the
alert
> and have a job that backs up that log only. Where would I get that
database
> name? The alert has it, does it store it in a system table in msdb?
> Thanks!
>
|||This is awesome. I set it up to test and am quite eager to deploy it to
production. Thank you very much.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:eSpn43UIEHA.2744@.TK2MSFTNGP10.phx.gbl...
> There is a group of Alert tokens that you can use...
> For instance, you could create a job that has one step
> Backup log [A-DBN] to disk = 'c:\[A-DBN].logbak'
> When the job is called from an Alert, the token will be replaced (even in
> the filename string... and the appropriate database log will be backed
up...
> But the job can not be run< except from an alert> , because that is the
only[color=darkblue]
> time the tokens will be replaced..
> For a complete list of Alert tokens, go to Gert Drapers web site
> http://www.sqldev.net/sqlagent/SQLAg...ns.htm#Example using TSQL
> step
>
> "Michelle" <michelle@.nospam.com> wrote in message
> news:eDmu1PNIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> backup
call[color=darkblue]
> will
> By
myself
>

> alert
> database
>

Job to Backup Log when Full

We would like to be able to read the database name that triggered the alert
and have a job that backs up that log only. Where would I get that database
name? The alert has it, does it store it in a system table in msdb?
Thanks!There is a group of Alert tokens that you can use...
For instance, you could create a job that has one step
Backup log [A-DBN] to disk = 'c:\[A-DBN].logbak'
When the job is called from an Alert, the token will be replaced (even in
the filename string... and the appropriate database log will be backed up...
But the job can not be run< except from an alert> , because that is the only
time the tokens will be replaced..
For a complete list of Alert tokens, go to Gert Drapers web site
http://www.sqldev.net/sqlagent/SQLA...ens.htm#Example using TSQL
step
"Michelle" <michelle@.nospam.com> wrote in message
news:eDmu1PNIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We have several servers with dozens of databases on each one. We have
> elected to group our maintenance jobs so that all database backups are
> consolidated into 4 separate jobs (alphabetically). We would like to
backup
> a log using our standard practices if it gets full. We don't want to call
> the 'consolidated' job because if the db is the last alphabetically, it
will
> have to go through all of the preceeding dbs before it gets to that log.
By
> that time, I could have gotten up out of bed and backed up the log myself

> We would like to be able to read the database name that triggered the
alert
> and have a job that backs up that log only. Where would I get that
database
> name? The alert has it, does it store it in a system table in msdb?
> Thanks!
>|||This is awesome. I set it up to test and am quite eager to deploy it to
production. Thank you very much.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:eSpn43UIEHA.2744@.TK2MSFTNGP10.phx.gbl...
> There is a group of Alert tokens that you can use...
> For instance, you could create a job that has one step
> Backup log [A-DBN] to disk = 'c:\[A-DBN].logbak'
> When the job is called from an Alert, the token will be replaced (even in
> the filename string... and the appropriate database log will be backed
up...
> But the job can not be run< except from an alert> , because that is the
only
> time the tokens will be replaced..
> For a complete list of Alert tokens, go to Gert Drapers web site
> http://www.sqldev.net/sqlagent/SQLA...ens.htm#Example using TSQL
> step
>
> "Michelle" <michelle@.nospam.com> wrote in message
> news:eDmu1PNIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> backup
call
> will
> By
myself
>

> alert
> database
>

Job to Backup Log when Full

We have several servers with dozens of databases on each one. We have
elected to group our maintenance jobs so that all database backups are
consolidated into 4 separate jobs (alphabetically). We would like to backup
a log using our standard practices if it gets full. We don't want to call
the 'consolidated' job because if the db is the last alphabetically, it will
have to go through all of the preceeding dbs before it gets to that log. By
that time, I could have gotten up out of bed and backed up the log myself :)
We would like to be able to read the database name that triggered the alert
and have a job that backs up that log only. Where would I get that database
name? The alert has it, does it store it in a system table in msdb?
Thanks!There is a group of Alert tokens that you can use...
For instance, you could create a job that has one step
Backup log [A-DBN] to disk = 'c:\[A-DBN].logbak'
When the job is called from an Alert, the token will be replaced (even in
the filename string... and the appropriate database log will be backed up...
But the job can not be run< except from an alert> , because that is the only
time the tokens will be replaced..
For a complete list of Alert tokens, go to Gert Drapers web site
http://www.sqldev.net/sqlagent/SQLAgentStepTokens.htm#Example using TSQL
step
"Michelle" <michelle@.nospam.com> wrote in message
news:eDmu1PNIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We have several servers with dozens of databases on each one. We have
> elected to group our maintenance jobs so that all database backups are
> consolidated into 4 separate jobs (alphabetically). We would like to
backup
> a log using our standard practices if it gets full. We don't want to call
> the 'consolidated' job because if the db is the last alphabetically, it
will
> have to go through all of the preceeding dbs before it gets to that log.
By
> that time, I could have gotten up out of bed and backed up the log myself
:)
> We would like to be able to read the database name that triggered the
alert
> and have a job that backs up that log only. Where would I get that
database
> name? The alert has it, does it store it in a system table in msdb?
> Thanks!
>|||This is awesome. I set it up to test and am quite eager to deploy it to
production. Thank you very much.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:eSpn43UIEHA.2744@.TK2MSFTNGP10.phx.gbl...
> There is a group of Alert tokens that you can use...
> For instance, you could create a job that has one step
> Backup log [A-DBN] to disk = 'c:\[A-DBN].logbak'
> When the job is called from an Alert, the token will be replaced (even in
> the filename string... and the appropriate database log will be backed
up...
> But the job can not be run< except from an alert> , because that is the
only
> time the tokens will be replaced..
> For a complete list of Alert tokens, go to Gert Drapers web site
> http://www.sqldev.net/sqlagent/SQLAgentStepTokens.htm#Example using TSQL
> step
>
> "Michelle" <michelle@.nospam.com> wrote in message
> news:eDmu1PNIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> > We have several servers with dozens of databases on each one. We have
> > elected to group our maintenance jobs so that all database backups are
> > consolidated into 4 separate jobs (alphabetically). We would like to
> backup
> > a log using our standard practices if it gets full. We don't want to
call
> > the 'consolidated' job because if the db is the last alphabetically, it
> will
> > have to go through all of the preceeding dbs before it gets to that log.
> By
> > that time, I could have gotten up out of bed and backed up the log
myself
> :)
> > We would like to be able to read the database name that triggered the
> alert
> > and have a job that backs up that log only. Where would I get that
> database
> > name? The alert has it, does it store it in a system table in msdb?
> >
> > Thanks!
> >
> >
>

Wednesday, March 28, 2012

Job System Table

Hello,
Three questions:
(1) Is there a table (a system table?) on sql server 2000 that will
give you a list of the jobs on the database and when they are
scheduled? Also,
(2) Is there a table on SQL server 2000 that will give you the list of
DTS packages?
(3) Does SQL server track dependencies between jobs and stored
procedures? That is does it store a reference to objects that a stored
procedure or DTS package uses? If so is this information available in
a table?
Thanks for the helpBonifide,
1 and 2 - yes. Download the following...it will help answer these questions
and maybe more.
SQL Server System Table Map
http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx
HTH
Jerry
"bonifide" <jeffsutthoff@.hotmail.com> wrote in message
news:1129748256.102327.303020@.o13g2000cwo.googlegroups.com...
> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
> Thanks for the help
>|||Look in the MSDB DB for sysjobs, sysjobsschedules, sysjobsteps, sysdtspackages
http://sqlservercode.blogspot.com/
"bonifide" wrote:
> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
> Thanks for the help
>|||Comments Inline
"bonifide" <jeffsutthoff@.hotmail.com> wrote in message
news:1129748256.102327.303020@.o13g2000cwo.googlegroups.com...
> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
There are multiple tables in msdb that together contain this information.
For jobs\databases, you will need to link sysjobsteps (for the database
information) and sysjobs. You will have to add sysjobservers if you are
using multi-server job administration. See the SQL 2000 System table map
for details.
> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
msdb.dbo.sysdtspackages
> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
No. SQL Server 7.0 and higher use late bindings so you can create objects
that refer to other objects that may not exist yet. There are some semsible
exceptions such as you cannot create a trigger on a table that does not
exist, but job steps can refer to nonexistent objects indefinitely.
> Thanks for the help
>
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

Job System Table

Hello,
Three questions:
(1) Is there a table (a system table?) on sql server 2000 that will
give you a list of the jobs on the database and when they are
scheduled? Also,
(2) Is there a table on SQL server 2000 that will give you the list of
DTS packages?
(3) Does SQL server track dependencies between jobs and stored
procedures? That is does it store a reference to objects that a stored
procedure or DTS package uses? If so is this information available in
a table?
Thanks for the helpBonifide,
1 and 2 - yes. Download the following...it will help answer these questions
and maybe more.
SQL Server System Table Map
http://www.microsoft.com/sql/techin.../systables.mspx
HTH
Jerry
"bonifide" <jeffsutthoff@.hotmail.com> wrote in message
news:1129748256.102327.303020@.o13g2000cwo.googlegroups.com...
> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
> Thanks for the help
>|||Look in the MSDB DB for sysjobs, sysjobsschedules, sysjobsteps, sysdtspackag
es
http://sqlservercode.blogspot.com/
"bonifide" wrote:

> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
> Thanks for the help
>|||Comments Inline
"bonifide" <jeffsutthoff@.hotmail.com> wrote in message
news:1129748256.102327.303020@.o13g2000cwo.googlegroups.com...
> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
There are multiple tables in msdb that together contain this information.
For jobs\databases, you will need to link sysjobsteps (for the database
information) and sysjobs. You will have to add sysjobservers if you are
using multi-server job administration. See the SQL 2000 System table map
for details.

> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
msdb.dbo.sysdtspackages

> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
No. SQL Server 7.0 and higher use late bindings so you can create objects
that refer to other objects that may not exist yet. There are some semsible
exceptions such as you cannot create a trigger on a table that does not
exist, but job steps can refer to nonexistent objects indefinitely.

> Thanks for the help
>
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

Job System Table

Hello,
Three questions:
(1) Is there a table (a system table?) on sql server 2000 that will
give you a list of the jobs on the database and when they are
scheduled? Also,
(2) Is there a table on SQL server 2000 that will give you the list of
DTS packages?
(3) Does SQL server track dependencies between jobs and stored
procedures? That is does it store a reference to objects that a stored
procedure or DTS package uses? If so is this information available in
a table?
Thanks for the help
Bonifide,
1 and 2 - yes. Download the following...it will help answer these questions
and maybe more.
SQL Server System Table Map
http://www.microsoft.com/sql/techinf...systables.mspx
HTH
Jerry
"bonifide" <jeffsutthoff@.hotmail.com> wrote in message
news:1129748256.102327.303020@.o13g2000cwo.googlegr oups.com...
> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
> Thanks for the help
>
|||Look in the MSDB DB for sysjobs, sysjobsschedules, sysjobsteps, sysdtspackages
http://sqlservercode.blogspot.com/
"bonifide" wrote:

> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
> Thanks for the help
>
|||Comments Inline
"bonifide" <jeffsutthoff@.hotmail.com> wrote in message
news:1129748256.102327.303020@.o13g2000cwo.googlegr oups.com...
> Hello,
> Three questions:
> (1) Is there a table (a system table?) on sql server 2000 that will
> give you a list of the jobs on the database and when they are
> scheduled? Also,
There are multiple tables in msdb that together contain this information.
For jobs\databases, you will need to link sysjobsteps (for the database
information) and sysjobs. You will have to add sysjobservers if you are
using multi-server job administration. See the SQL 2000 System table map
for details.

> (2) Is there a table on SQL server 2000 that will give you the list of
> DTS packages?
msdb.dbo.sysdtspackages

> (3) Does SQL server track dependencies between jobs and stored
> procedures? That is does it store a reference to objects that a stored
> procedure or DTS package uses? If so is this information available in
> a table?
No. SQL Server 7.0 and higher use late bindings so you can create objects
that refer to other objects that may not exist yet. There are some semsible
exceptions such as you cannot create a trigger on a table that does not
exist, but job steps can refer to nonexistent objects indefinitely.

> Thanks for the help
>
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

Job succeeds manually but fails if scheduled

My client has a number of jobs that are run overnight. We've set them
up to email me when they're completed. Every morning I get in to a
bunch of emails like this:

<quote
JOB RUN:'Tech Pubs Email Notification' was run on 18/03/2006 at
00:00:00
DURATION:0 hours, 0 minutes, 0 seconds
STATUS: Succeeded
MESSAGES:The job succeeded. The Job was invoked by Schedule 10 (Send
Mail). The last step to run was step 1 (Send Mail).
</quote
However, the most important job - the database backup - fails every
time.

<quote>
JOB RUN:'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1''
was run on 20/03/2006 at 18:00:00
DURATION:0 hours, 0 minutes, 2 seconds
STATUS: Failed
MESSAGES:The job failed. The Job was invoked by Schedule 7 (Schedule
1). The last step to run was step 1 (Step 1).
</quote
What's strange is that the job runs successfully if you kick it off
manually (in EM: right-click and "Start Job")!!! Does anyone have any
idea of why that might be? Where to look for diagnostic information?

TIA

Edwardteddysnips@.hotmail.com wrote:
> My client has a number of jobs that are run overnight. We've set them
> up to email me when they're completed. Every morning I get in to a
> bunch of emails like this:
> <quote>
> JOB RUN:'Tech Pubs Email Notification' was run on 18/03/2006 at
> 00:00:00
> DURATION:0 hours, 0 minutes, 0 seconds
> STATUS: Succeeded
> MESSAGES:The job succeeded. The Job was invoked by Schedule 10 (Send
> Mail). The last step to run was step 1 (Send Mail).
> </quote>
> However, the most important job - the database backup - fails every
> time.
> <quote>
> JOB RUN:'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1''
> was run on 20/03/2006 at 18:00:00
> DURATION:0 hours, 0 minutes, 2 seconds
> STATUS: Failed
> MESSAGES:The job failed. The Job was invoked by Schedule 7 (Schedule
> 1). The last step to run was step 1 (Step 1).
> </quote>
> What's strange is that the job runs successfully if you kick it off
> manually (in EM: right-click and "Start Job")!!! Does anyone have any
> idea of why that might be? Where to look for diagnostic information?
> TIA
> Edward

Edward,

Have you got the right permissions?

This might sound a bit obvious but its usually the case. You might not
be the owner of the package and the system will only schedule the job
to run if the permissions are correct.

Bryan|||Bryan wrote:
> teddysnips@.hotmail.com wrote:
[...]
>
> Edward,
> Have you got the right permissions?
> This might sound a bit obvious but its usually the case. You might not
> be the owner of the package and the system will only schedule the job
> to run if the permissions are correct.
> Bryan

I would have assumed so, but I'll check. Thanks for the suggestion.

Edward|||Bryan wrote:
[...]
> Edward,
> Have you got the right permissions?
> This might sound a bit obvious but its usually the case. You might not
> be the owner of the package and the system will only schedule the job
> to run if the permissions are correct.

I checked on this today. All the jobs that run correctly have exactly
the same owners/permissions as the job that fails. I can't find any
attribute of the job (apart from what it actually does, obviously) that
distinguishes it from any of the other, successful jobs.

One other thing of which I was not aware. Apparently this job had been
scheduled successfully up until about a week ago, when it began
failing.

Any further thoughts/ideas?

TIA

Edward|||Hi Edward,

To be honest I don't ( I hate admitting defeat though....)

I have encountered this problem in the past especially when picking up
from any previous owners of packages.
One solution I have done is to copy the code from one package and dump
it into a package that is being allowed to run but with a different
owner.
This usually confirmed to myself that the problem must a a Owner /
Permission issue.

Apart from that I'm at a loss to recommend any other course of action.|||(teddysnips@.hotmail.com) writes:
> I checked on this today. All the jobs that run correctly have exactly
> the same owners/permissions as the job that fails. I can't find any
> attribute of the job (apart from what it actually does, obviously) that
> distinguishes it from any of the other, successful jobs.
> One other thing of which I was not aware. Apparently this job had been
> scheduled successfully up until about a week ago, when it began
> failing.
> Any further thoughts/ideas?

Check View History for the job. Don't miss to check View Step History.

Unfortunately, jobs that set up from a maintenance plan does not seem to
write very much useful information, so I'm not really expecting this to
give you anything. (But check nevertheless.) I the maintenance plan has
its own log somewhere, but I don't remember where - or if there was anything
that useful in it.

May you should scrap the plan, and set up the jobs without it.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||<teddysnips@.hotmail.com> wrote in message
news:1142932717.825816.151430@.z34g2000cwc.googlegr oups.com...
> My client has a number of jobs that are run overnight. We've set them
> up to email me when they're completed. Every morning I get in to a
> bunch of emails like this:
> <quote>
> JOB RUN: 'Tech Pubs Email Notification' was run on 18/03/2006 at
> 00:00:00
> DURATION: 0 hours, 0 minutes, 0 seconds
> STATUS: Succeeded
> MESSAGES: The job succeeded. The Job was invoked by Schedule 10 (Send
> Mail). The last step to run was step 1 (Send Mail).
> </quote>
> However, the most important job - the database backup - fails every
> time.
> <quote>
> JOB RUN: 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1''
> was run on 20/03/2006 at 18:00:00
> DURATION: 0 hours, 0 minutes, 2 seconds
> STATUS: Failed
> MESSAGES: The job failed. The Job was invoked by Schedule 7 (Schedule
> 1). The last step to run was step 1 (Step 1).
> </quote>
> What's strange is that the job runs successfully if you kick it off
> manually (in EM: right-click and "Start Job")!!! Does anyone have any
> idea of why that might be? Where to look for diagnostic information?
> TIA
> Edward

If it isn't the owner of the job step (sa would be good if sa owns the
database), then check for proper disk
space in the backup destination.

JOB STEPS OUT OF ORDER

Hi People, I'm facing a very strange situation !
I recently imported some jobs using a script and I
realized that all the steps are out of order when I click
on start job, for example I HAVE 4 steps and it shows like
this 4 - 2 - 3 - 1 ! WHAT IS THAT '
I also notice that when I create new JOBS all order for
the steps are wrong ! WHATA IS THAT JESUS !
Please HELP ME ! THANK'S !
.I bet you installed the MS03_031 SQL Server Patch. After
I installed this patch I had the same problem. You / we
will need to wait till the next patch. :(
-Stephen
>--Original Message--
>I know this isn't what you looking for but can you
reorder them? have you
>change your sort order in sql?
>
>Yovan Fernandez
>"Roberto Carrasco" <Roberto_carrasco@.msn.com> wrote in
message
>news:058601c377d8$151d5130$a101280a@.phx.gbl...
>> Hi People, I'm facing a very strange situation !
>> I recently imported some jobs using a script and I
>> realized that all the steps are out of order when I
click
>> on start job, for example I HAVE 4 steps and it shows
like
>> this 4 - 2 - 3 - 1 ! WHAT IS THAT '
>> I also notice that when I create new JOBS all order for
>> the steps are wrong ! WHATA IS THAT JESUS !
>> Please HELP ME ! THANK'S !
>> .
>>
>
>.
>|||Hi,
I Installed ! Jesus ! This is terrible ! This kind of
thing that happen, very sad.
We wait !
Thank's !
>--Original Message--
>I bet you installed the MS03_031 SQL Server Patch. After
>I installed this patch I had the same problem. You / we
>will need to wait till the next patch. :(
>-Stephen
>>--Original Message--
>>I know this isn't what you looking for but can you
>reorder them? have you
>>change your sort order in sql?
>>
>>Yovan Fernandez
>>"Roberto Carrasco" <Roberto_carrasco@.msn.com> wrote in
>message
>>news:058601c377d8$151d5130$a101280a@.phx.gbl...
>> Hi People, I'm facing a very strange situation !
>> I recently imported some jobs using a script and I
>> realized that all the steps are out of order when I
>click
>> on start job, for example I HAVE 4 steps and it shows
>like
>> this 4 - 2 - 3 - 1 ! WHAT IS THAT '
>> I also notice that when I create new JOBS all order for
>> the steps are wrong ! WHATA IS THAT JESUS !
>> Please HELP ME ! THANK'S !
>> .
>>
>>
>>.
>.
>|||I am having the same problem. Were you able to fins a solution?
Ashwin Mahaja
--
amahaja
----
amahajan's Profile: http://www.msusenet.com/member.php?userid=39
View this thread: http://www.msusenet.com/t-322648

Job step fails with Error 7399 and 7312

We have a job that intermittently fails on the same step with the same error.
Identical jobs that run before this one always succeed. The step uses the
following T-SQL to update a table on a linked server:
DBCC TRACEON (7300, 3604)
INSERT INTO <linkedservername>.ods.dbo.[!ODSReplicationTimes ]
([Date], Imports, Div)
VALUES (dbo.DateOnly(DATEADD(hh, 7, GETDATE())), GETDATE(), 'wbd')
if the job fails, it is exactly the default timeout of 10 minutes after the
start time, and results in this error:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned
0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.
on failure, this step proceeds to a similar step which calls a sproc:
DBCC TRACEON (7300, 3604)
CheckFutureStatus 'JobName Finish','!Check Status WBD',240,240,3,'wbd'
yielding a similar result:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::SetData returned 0x80004005:
]. [SQLSTATE 01000] (Error 7300). The step failed.
I've set the step to retry 3 times/5 minutes to no avail. the traceon
doesn't give any additional information.
Any ideas?
Hello
Did you try to perform a SQL Profiler trace on the server that you have
configured as the linked server to see what happens on that server. I'm
assuming that the query should finish within the 10 minute timeout period.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||What Events/Data would you want to see. anything in particular for this
situation?
"Pankaj Agarwal [MSFT]" wrote:

> Hello
> Did you try to perform a SQL Profiler trace on the server that you have
> configured as the linked server to see what happens on that server. I'm
> assuming that the query should finish within the 10 minute timeout period.
> Thank you for using Microsoft newsgroups.
> Sincerely
> Pankaj Agarwal
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
|||I think it would be beneficial to capture the Execution Statistics, Stored
Procedure and TSQL related events. Also capture SP Recompile, Database File
Autogrow. This would give you at least a starting point to see what event
is the query stuck on. I would also download the blocker script from the
following KB article and run that to see if there is any blocking when the
query does not complete during the 10 min timeout interval.
271509 INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/?id=271509
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Job step fails with Error 7399 and 7312

We have a job that intermittently fails on the same step with the same error
.
Identical jobs that run before this one always succeed. The step uses the
following T-SQL to update a table on a linked server:
DBCC TRACEON (7300, 3604)
INSERT INTO <linkedservername>.ods.dbo.[!ODSReplicationTimes]
([Date], Imports, Div)
VALUES (dbo.DateOnly(DATEADD(hh, 7, GETDATE())), GETDATE(), 'wbd')
if the job fails, it is exactly the default timeout of 10 minutes after the
start time, and results in this error:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE D
B error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned
0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.
on failure, this step proceeds to a similar step which calls a sproc:
DBCC TRACEON (7300, 3604)
CheckFutureStatus 'JobName Finish','!Check Status WBD',240,240,3,'wbd'
yielding a similar result:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE D
B error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::SetData returned 0x8000
4005:
]. [SQLSTATE 01000] (Error 7300). The step failed.
I've set the step to retry 3 times/5 minutes to no avail. the traceon
doesn't give any additional information.
Any ideas?Hello
Did you try to perform a SQL Profiler trace on the server that you have
configured as the linked server to see what happens on that server. I'm
assuming that the query should finish within the 10 minute timeout period.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||What Events/Data would you want to see. anything in particular for this
situation?
"Pankaj Agarwal [MSFT]" wrote:

> Hello
> Did you try to perform a SQL Profiler trace on the server that you have
> configured as the linked server to see what happens on that server. I'm
> assuming that the query should finish within the 10 minute timeout period.
> Thank you for using Microsoft newsgroups.
> Sincerely
> Pankaj Agarwal
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>|||I think it would be beneficial to capture the Execution Statistics, Stored
Procedure and TSQL related events. Also capture SP Recompile, Database File
Autogrow. This would give you at least a starting point to see what event
is the query stuck on. I would also download the blocker script from the
following KB article and run that to see if there is any blocking when the
query does not complete during the 10 min timeout interval.
271509 INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/?id=271509
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

Job Status Wrong

Hello,
In my Enterprise Manager i see one job that i know its running(i look
locally on server) and jobs status appear like job is not executing(job
status is wrong)
Is there any patch to apply to EM?
Thanks and best regards.
Hi
I take it that by wrong status, you mean it is showing as sleeping under
current activity in Enterprise Manager. This is quiet normal as Sql Server
pages in and out processes as it runs them. If you keep refreshing it you may
catch it as active.
If you want to check that it is actually doing something, you can monitor it
with profiler or if you double click on the current activity, you get details
of the current SQL statement being performed. If you refresh that you should
see it change.
Hope this helps
John
"CC&JM" wrote:

> Hello,
> In my Enterprise Manager i see one job that i know its running(i look
> locally on server) and jobs status appear like job is not executing(job
> status is wrong)
> Is there any patch to apply to EM?
> Thanks and best regards.
|||Hello John,
Thanks for your answer, now i see the status of the job quit well but
yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
Date" showed 12:00.
I know that the problem was with my EM because in the EM of my partner i saw
the job status normally.
Thanks John,
Best regards
"John Bandettini" wrote:
[vbcol=seagreen]
> Hi
> I take it that by wrong status, you mean it is showing as sleeping under
> current activity in Enterprise Manager. This is quiet normal as Sql Server
> pages in and out processes as it runs them. If you keep refreshing it you may
> catch it as active.
> If you want to check that it is actually doing something, you can monitor it
> with profiler or if you double click on the current activity, you get details
> of the current SQL statement being performed. If you refresh that you should
> see it change.
> Hope this helps
> John
> "CC&JM" wrote:
|||Hi
I misunderstood your problem, I thought you were looking at current
activity. If you were looking at jobs and the job did not seem to be running,
did you refresh the display? Once you have opened something in Enterprise
manager, like jobs it will not automatically refresh. You need to either
right click and choose refresh or press F5.
Regards
John
"CC&JM" wrote:
[vbcol=seagreen]
> Hello John,
> Thanks for your answer, now i see the status of the job quit well but
> yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
> and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
> Date" showed 12:00.
> I know that the problem was with my EM because in the EM of my partner i saw
> the job status normally.
> Thanks John,
> Best regards
> "John Bandettini" wrote:
sql

Job Status Wrong

Hello,
In my Enterprise Manager i see one job that i know its running(i look
locally on server) and jobs status appear like job is not executing(job
status is wrong)
Is there any patch to apply to EM?
Thanks and best regards.Hi
I take it that by wrong status, you mean it is showing as sleeping under
current activity in Enterprise Manager. This is quiet normal as Sql Server
pages in and out processes as it runs them. If you keep refreshing it you may
catch it as active.
If you want to check that it is actually doing something, you can monitor it
with profiler or if you double click on the current activity, you get details
of the current SQL statement being performed. If you refresh that you should
see it change.
Hope this helps
John
"CC&JM" wrote:
> Hello,
> In my Enterprise Manager i see one job that i know its running(i look
> locally on server) and jobs status appear like job is not executing(job
> status is wrong)
> Is there any patch to apply to EM?
> Thanks and best regards.|||Hello John,
Thanks for your answer, now i see the status of the job quit well but
yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
Date" showed 12:00.
I know that the problem was with my EM because in the EM of my partner i saw
the job status normally.
Thanks John,
Best regards
"John Bandettini" wrote:
> Hi
> I take it that by wrong status, you mean it is showing as sleeping under
> current activity in Enterprise Manager. This is quiet normal as Sql Server
> pages in and out processes as it runs them. If you keep refreshing it you may
> catch it as active.
> If you want to check that it is actually doing something, you can monitor it
> with profiler or if you double click on the current activity, you get details
> of the current SQL statement being performed. If you refresh that you should
> see it change.
> Hope this helps
> John
> "CC&JM" wrote:
> > Hello,
> >
> > In my Enterprise Manager i see one job that i know its running(i look
> > locally on server) and jobs status appear like job is not executing(job
> > status is wrong)
> > Is there any patch to apply to EM?
> >
> > Thanks and best regards.|||Hi
I misunderstood your problem, I thought you were looking at current
activity. If you were looking at jobs and the job did not seem to be running,
did you refresh the display? Once you have opened something in Enterprise
manager, like jobs it will not automatically refresh. You need to either
right click and choose refresh or press F5.
Regards
John
"CC&JM" wrote:
> Hello John,
> Thanks for your answer, now i see the status of the job quit well but
> yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
> and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
> Date" showed 12:00.
> I know that the problem was with my EM because in the EM of my partner i saw
> the job status normally.
> Thanks John,
> Best regards
> "John Bandettini" wrote:
> > Hi
> >
> > I take it that by wrong status, you mean it is showing as sleeping under
> > current activity in Enterprise Manager. This is quiet normal as Sql Server
> > pages in and out processes as it runs them. If you keep refreshing it you may
> > catch it as active.
> >
> > If you want to check that it is actually doing something, you can monitor it
> > with profiler or if you double click on the current activity, you get details
> > of the current SQL statement being performed. If you refresh that you should
> > see it change.
> >
> > Hope this helps
> >
> > John
> >
> > "CC&JM" wrote:
> >
> > > Hello,
> > >
> > > In my Enterprise Manager i see one job that i know its running(i look
> > > locally on server) and jobs status appear like job is not executing(job
> > > status is wrong)
> > > Is there any patch to apply to EM?
> > >
> > > Thanks and best regards.

Job Status Wrong

Hello,
In my Enterprise Manager i see one job that i know its running(i look
locally on server) and jobs status appear like job is not executing(job
status is wrong)
Is there any patch to apply to EM?
Thanks and best regards.Hi
I take it that by wrong status, you mean it is showing as sleeping under
current activity in Enterprise Manager. This is quiet normal as Sql Server
pages in and out processes as it runs them. If you keep refreshing it you ma
y
catch it as active.
If you want to check that it is actually doing something, you can monitor it
with profiler or if you double click on the current activity, you get detail
s
of the current SQL statement being performed. If you refresh that you should
see it change.
Hope this helps
John
"CC&JM" wrote:

> Hello,
> In my Enterprise Manager i see one job that i know its running(i look
> locally on server) and jobs status appear like job is not executing(job
> status is wrong)
> Is there any patch to apply to EM?
> Thanks and best regards.|||Hello John,
Thanks for your answer, now i see the status of the job quit well but
yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
Date" showed 12:00.
I know that the problem was with my EM because in the EM of my partner i saw
the job status normally.
Thanks John,
Best regards
"John Bandettini" wrote:
[vbcol=seagreen]
> Hi
> I take it that by wrong status, you mean it is showing as sleeping under
> current activity in Enterprise Manager. This is quiet normal as Sql Server
> pages in and out processes as it runs them. If you keep refreshing it you
may
> catch it as active.
> If you want to check that it is actually doing something, you can monitor
it
> with profiler or if you double click on the current activity, you get deta
ils
> of the current SQL statement being performed. If you refresh that you shou
ld
> see it change.
> Hope this helps
> John
> "CC&JM" wrote:
>|||Hi
I misunderstood your problem, I thought you were looking at current
activity. If you were looking at jobs and the job did not seem to be running
,
did you refresh the display? Once you have opened something in Enterprise
manager, like jobs it will not automatically refresh. You need to either
right click and choose refresh or press F5.
Regards
John
"CC&JM" wrote:
[vbcol=seagreen]
> Hello John,
> Thanks for your answer, now i see the status of the job quit well but
> yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
> and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Ru
n
> Date" showed 12:00.
> I know that the problem was with my EM because in the EM of my partner i s
aw
> the job status normally.
> Thanks John,
> Best regards
> "John Bandettini" wrote:
>

Friday, March 30, 2012

Jobs

JOBS

Jobs

Jobs

Jobs

JOBS

JOBS

Job to Backup Log when Full

Job to Backup Log when Full

Job to Backup Log when Full

Wednesday, March 28, 2012

Job System Table

Job System Table

Job System Table

Job succeeds manually but fails if scheduled

JOB STEPS OUT OF ORDER

Job step fails with Error 7399 and 7312

Job step fails with Error 7399 and 7312

Job Status Wrong

Job Status Wrong

Job Status Wrong

JDBC Driver issue

Blog Archive

About Me