Experts Exchange connects you with the people and services you need so you can get back to work.
Improve company productivity with a Business Account.Sign Up
WHEN 0 THEN 'Not idle or suspended.'
WHEN 1 THEN 'Executing.'
WHEN 2 THEN 'Waiting for thread.'
WHEN 3 THEN 'Between retries.'
WHEN 4 THEN 'Idle.'
WHEN 5 THEN 'Suspended.'
WHEN 7 THEN 'Performing completion actions.'
ELSE 'Unknown Current Execution Status of ' + CAST(current_execution_status AS VARCHAR(3))
FROM OPENQUERY ([Your Server Name Here],'EXEC msdb.dbo.sp_help_job @job_name = ''BalanceComparisonAggregation'', @job_aspect = ''JOB''');
Open in new window
Msg 7411, Level 16, State 1, Line 3
Server 'Your Server Name Here' is not configured for DATA ACCESS.
exec sp_serveroption @server = 'Your Server Name Here', @optname = 'DATA ACCESS', @optvalue = 'TRUE'
USE msdb ;
EXEC dbo.sp_help_job @job_aspect = 'JOB', @execution_status = 1, @job_name = 'BalanceComparisonAggregation'
job_id originating_server name enabled description start_step_id category owner notify_level_eventlog notify_level_email notify_level_netsend notify_level_page notify_email_operator notify_netsend_operator notify_page_operator delete_level date_created date_modified version_number last_run_date last_run_time last_run_outcome next_run_date next_run_time next_run_schedule_id current_execution_status current_execution_step current_retry_attempt has_step has_schedule has_target type
82B5A4FD-BE1B-40BF-9B38-D563EAD741F4 VM-SVR-29 BalanceComparisonAggregation 1 Pull in the required data for the balance comparison spreadsheet. Due to the nature of the queries required to gather all the data, across 16 different databases on 2 different servers, doing this in real time (via Excel) takes too long. This job will pull in, on an hourly basis, all the data required for a near realtime view of the balances. This mechanism also allows for significantly easier customisation and for the controlling/hiding of dead accounts. 1 [Uncategorized (Local)] XXXXDomainXXXX\RichardQ 0 0 0 0 (unknown) (unknown) (unknown) 0 2011-09-19 15:01:33.923 2011-09-21 13:24:17.530 39 20110928 170958 1 20110928 180000 16 1 3 (CS+ Costing Sales Order Processing) 0 8 1 1 1
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.