no job history

sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisRYes, you can define the limit. EM, right-click Agent, Properties. On one of the tabs, you can set
this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history for several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJobHistory table can hold?
> Any other ideas?
> TIA, ChrisR
>|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>> sql2k sp3a
>> One of my servers doesnt retain very much job history. I have no history
>> for several jobs that run once or more per day. Is there a limit to the
>> amount of records the SysJobHistory table can hold? Any other ideas?
>> TIA, ChrisR
>sql

no job history

sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisRYes, you can define the limit. EM, right-click Agent, Properties. On one of
the tabs, you can set
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...[vb
col=seagreen]
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history f
or several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJob
History table can hold?
> Any other ideas?
> TIA, ChrisR
>[/vbcol]|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>

no job history

sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisR
Yes, you can define the limit. EM, right-click Agent, Properties. On one of the tabs, you can set
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history for several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJobHistory table can hold?
> Any other ideas?
> TIA, ChrisR
>
|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>

No history information for jobs

Hi All,
When I right click on some jobs in sql server and select view job history, s
ometimes I get "There is no history information for this job". I was able to
see job history few hours/days back. I have not cleared logs nor restarted
the box. But still i am not
able to see any history information. I can however see history information o
n other jobs. Can you tell me why is sql server wiping of job history inform
ation for some jobs. What can i do to prevent it?
Regards,
PROHave you tried increasing the values in SQLAgent-->Properties-->Job
System tab? Look at the Maximum job history log size(rows) and Maximum
job history rows per job values. See if that works for you.
Mark Allison, SQL Server MVP
PRashanth wrote:

> Hi All,
> When I right click on some jobs in sql server and select view job history, sometim
es I get "There is no history information for this job". I was able to see job histo
ry few hours/days back. I have not cleared logs nor restarted the box. But still i a
m n
ot able to see any history information. I can however see history information on other jobs
. Can you tell me why is sql server wiping of job history information for some jobs. What c
an i do to prevent it?
> Regards,
> PRO|||Hi Mark,
Thank you very much for your reply. The current setting of my sql server
is Max. job history log size(rows): 500000
max job history rows per job: 1000
Also, i dont understand why there is no job history for only some of the
jobs
Regards,
PRO
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||--
|
| Hi Mark,
|
| Thank you very much for your reply. The current setting of my sql server
| is Max. job history log size(rows): 500000
| max job history rows per job: 1000
|
| Also, i dont understand why there is no job history for only some of the
| jobs
|
| Regards,
| PRO
--
It is possible that the job history of more frequently running jobs are
overwriting those of the less frequently running jobs. To address this,
increase your max job history log size and decrease your max job history
rows per job.
Hope this helps,
Eric Cardenas
SQL Server support

Nightly refresh

Please help. Taking over somebody's half done job. Here is my
situation:
I have Database A (with Transactional data), Database B(Archived
data). I need to bring both Database A and Database B Into Database C
after cleaning for reporting purposes.
Database B should be brought into Database C once it is archived data
and Database A should be brought into Database C with differentials
only.
Also Database A and Database B do not have any timestamps in any
tables.
Currently Database C is cleared every night to load Database A.
Database B is not loaded since it takes 15 hours to complete the job.
I can successfully bring Database A into Database C with
differentials. Now I would want to add Database B into Database C and
keep it as is and would want to load only the differentials into C
from A without clearing C.
Please suggest some workarounds.
Thank YouDoes it take 15 hours to load database C with the data from database A? or
15 hours to load database B into database C?
What size of databases are we talking about here?
You also said you can already bring A into C with differentials but then in
the next sentence you said you want to load only the differentials into C
from A without clearing C.
If you could clarify some of those it would make it easier...
--
Geoff Chovaz
MCTS: SQL Server 2005
MCITP: Database Administrator
MCITP: Database Developer
<rohini.srigiriraju@.gmail.com> wrote in message
news:1190211476.759596.123330@.50g2000hsm.googlegroups.com...
> Please help. Taking over somebody's half done job. Here is my
> situation:
> I have Database A (with Transactional data), Database B(Archived
> data). I need to bring both Database A and Database B Into Database C
> after cleaning for reporting purposes.
> Database B should be brought into Database C once it is archived data
> and Database A should be brought into Database C with differentials
> only.
> Also Database A and Database B do not have any timestamps in any
> tables.
> Currently Database C is cleared every night to load Database A.
> Database B is not loaded since it takes 15 hours to complete the job.
> I can successfully bring Database A into Database C with
> differentials. Now I would want to add Database B into Database C and
> keep it as is and would want to load only the differentials into C
> from A without clearing C.
> Please suggest some workarounds.
> Thank You
>|||Restore DB B to DB D.
Differential load DB C into DB D.
Differential load DB A into DB D.
Rename DB C to DB E (in case you need it later)
Rename DB D to DB C.
Set up regular differential load DB A to (the new) DB C.
Drop DB E.
hth
Quentin
<rohini.srigiriraju@.gmail.com> wrote in message
news:1190211476.759596.123330@.50g2000hsm.googlegroups.com...
> Please help. Taking over somebody's half done job. Here is my
> situation:
> I have Database A (with Transactional data), Database B(Archived
> data). I need to bring both Database A and Database B Into Database C
> after cleaning for reporting purposes.
> Database B should be brought into Database C once it is archived data
> and Database A should be brought into Database C with differentials
> only.
> Also Database A and Database B do not have any timestamps in any
> tables.
> Currently Database C is cleared every night to load Database A.
> Database B is not loaded since it takes 15 hours to complete the job.
> I can successfully bring Database A into Database C with
> differentials. Now I would want to add Database B into Database C and
> keep it as is and would want to load only the differentials into C
> from A without clearing C.
> Please suggest some workarounds.
> Thank You
>

next run date

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?
Can you post the results of the following query here:
SELECT * FROM msdb..sysjobschedules s1
WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
WHERE s2.job_id = s1.job_id )
AND s2.name = <jobname> );
Replace <jobname> with the name of your job.
Anith
|||Hi,
Below are the results:
schedule_id job_id name
enabled
-- --
37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
freq_typefreq_intervalfreq_subday_typefreq_subday_interval
8 4 1 0
freq_relative_intervalfreq_recurrence_factor
active_start_dateactive_end_date
0 1 2008031099991231
active_start_timeactive_end_timenext_run_datenext_run_time
100000 235959 0 0
date_created
03/10/2008 15:27:27.27
"Anith Sen" wrote:

> Can you post the results of the following query here:
> SELECT * FROM msdb..sysjobschedules s1
> WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> WHERE s2.job_id = s1.job_id )
> AND s2.name = <jobname> );
> Replace <jobname> with the name of your job.
> --
> Anith
>
>
|||I see that the next_run_date and next_run_time is not getting inserted into
the sysjobschedules table in msdb database after I create the job. What might
be the reason that this is not getting inserted? This works correctly on
other servers. Is this a permissions issue?
Thanks in advance.
"ronnie" wrote:
[vbcol=seagreen]
> Hi,
> Below are the results:
> schedule_id job_id name
> enabled
> -- --
> --
> 37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
> freq_typefreq_intervalfreq_subday_typefreq_subday_interval
> ----
> 8 4 1 0
> freq_relative_intervalfreq_recurrence_factor
> active_start_dateactive_end_date
> --
> 0 1 2008031099991231
>
> active_start_timeactive_end_timenext_run_datenext_run_time
> ----
> 100000 235959 0 0
>
> date_created
> --
> 03/10/2008 15:27:27.27
>
>
>
>
>
> "Anith Sen" wrote:

next run date

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?Can you post the results of the following query here:
SELECT * FROM msdb..sysjobschedules s1
WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
WHERE s2.job_id = s1.job_id )
AND s2.name = <jobname> );
Replace <jobname> with the name of your job.
--
Anith|||Hi,
Below are the results:
schedule_id job_id name
enabled
-- --
-- --
37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test 1
freq_type freq_interval freq_subday_type freq_subday_interval
-- -- -- --
8 4 1 0
freq_relative_interval freq_recurrence_factor
active_start_date active_end_date
-- --
-- --
0 1 20080310 99991231
active_start_time active_end_time next_run_date next_run_time
-- -- -- --
100000 235959 0 0
date_created
--
03/10/2008 15:27:27.27
"Anith Sen" wrote:
> Can you post the results of the following query here:
> SELECT * FROM msdb..sysjobschedules s1
> WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> WHERE s2.job_id = s1.job_id )
> AND s2.name = <jobname> );
> Replace <jobname> with the name of your job.
> --
> Anith
>
>|||I see that the next_run_date and next_run_time is not getting inserted into
the sysjobschedules table in msdb database after I create the job. What might
be the reason that this is not getting inserted? This works correctly on
other servers. Is this a permissions issue?
Thanks in advance.
"ronnie" wrote:
> Hi,
> Below are the results:
> schedule_id job_id name
> enabled
> -- --
> -- --
> 37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test 1
> freq_type freq_interval freq_subday_type freq_subday_interval
> -- -- -- --
> 8 4 1 0
> freq_relative_interval freq_recurrence_factor
> active_start_date active_end_date
> -- --
> -- --
> 0 1 20080310 99991231
>
> active_start_time active_end_time next_run_date next_run_time
> -- -- -- --
> 100000 235959 0 0
>
> date_created
> --
> 03/10/2008 15:27:27.27
>
>
>
>
>
> "Anith Sen" wrote:
> > Can you post the results of the following query here:
> >
> > SELECT * FROM msdb..sysjobschedules s1
> > WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> > WHERE s2.job_id = s1.job_id )
> > AND s2.name = <jobname> );
> >
> > Replace <jobname> with the name of your job.
> >
> > --
> > Anith
> >
> >
> >

newsgroup for DBA job Posting...

Where would one post a job for a Sr. DBA position (San Diego area) ?
Thanks in advance
Greg Jackson
PDX, Oregon
careerbuilder?
monster?
hotjobs?
....
Keith
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:uGzJZHDaEHA.996@.TK2MSFTNGP12.phx.gbl...
> Where would one post a job for a Sr. DBA position (San Diego area) ?
>
>
> Thanks in advance
>
> Greg Jackson
> PDX, Oregon
>
|||I vote for Careerbuilder.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uvJfiLDaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> careerbuilder?
> monster?
> hotjobs?
> ...
> --
> Keith
>
> "Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
> news:uGzJZHDaEHA.996@.TK2MSFTNGP12.phx.gbl...
>
|||I thought you might.
Keith
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23xGoDqDaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> I vote for Careerbuilder.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:uvJfiLDaEHA.3480@.TK2MSFTNGP11.phx.gbl...
>

newsgroup for DBA job Posting...

Where would one post a job for a Sr. DBA position (San Diego area) ?
Thanks in advance
Greg Jackson
PDX, Oregoncareerbuilder?
monster?
hotjobs?
...
--
Keith
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:uGzJZHDaEHA.996@.TK2MSFTNGP12.phx.gbl...
> Where would one post a job for a Sr. DBA position (San Diego area) ?
>
>
> Thanks in advance
>
> Greg Jackson
> PDX, Oregon
>|||I vote for Careerbuilder. :)
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uvJfiLDaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> careerbuilder?
> monster?
> hotjobs?
> ...
> --
> Keith
>
> "Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
> news:uGzJZHDaEHA.996@.TK2MSFTNGP12.phx.gbl...
> > Where would one post a job for a Sr. DBA position (San Diego area) ?
> >
> >
> >
> >
> > Thanks in advance
> >
> >
> >
> > Greg Jackson
> > PDX, Oregon
> >
> >
>|||I thought you might.
--
Keith
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23xGoDqDaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> I vote for Careerbuilder. :)
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:uvJfiLDaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > careerbuilder?
> > monster?
> > hotjobs?
> > ...
> >
> > --
> > Keith
> >
> >
> > "Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
> > news:uGzJZHDaEHA.996@.TK2MSFTNGP12.phx.gbl...
> > > Where would one post a job for a Sr. DBA position (San Diego area) ?
> > >
> > >
> > >
> > >
> > > Thanks in advance
> > >
> > >
> > >
> > > Greg Jackson
> > > PDX, Oregon
> > >
> > >
> >
>

newsgroup for DBA job Posting...

Where would one post a job for a Sr. DBA position (San Diego area) ?
Thanks in advance
Greg Jackson
PDX, Oregoncareerbuilder?
monster?
hotjobs?
...
Keith
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:uGzJZHDaEHA.996@.TK2MSFTNGP12.phx.gbl...
> Where would one post a job for a Sr. DBA position (San Diego area) ?
>
>
> Thanks in advance
>
> Greg Jackson
> PDX, Oregon
>|||I vote for Careerbuilder.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uvJfiLDaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> careerbuilder?
> monster?
> hotjobs?
> ...
> --
> Keith
>
> "Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
> news:uGzJZHDaEHA.996@.TK2MSFTNGP12.phx.gbl...
>|||I thought you might.
Keith
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23xGoDqDaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> I vote for Careerbuilder.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:uvJfiLDaEHA.3480@.TK2MSFTNGP11.phx.gbl...
>