June 30, 2011 at 2:39 am
How to all jobs move from sql server 2000 to sql server 2008..?
June 30, 2011 at 2:47 am
natarajan.p (6/30/2011)
How to all jobs move from sql server 2000 to sql server 2008..?
take a script using gui in 2000 and run it to 2008.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 4, 2011 at 3:15 am
which database i want to run the script..msdb or master..?
July 4, 2011 at 3:17 am
when i run the script i got this error...?
Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
July 4, 2011 at 3:25 am
Coolroof (7/4/2011)
when i run the script i got this error...?Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Do you create the login name while migrating from 2000 to 2008.
Open the script an check the name (owner_login_name) find the login is there in your new server
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 4, 2011 at 3:29 am
i login in windows authendication can i give domain user name..?
July 4, 2011 at 3:38 am
i give owner name is domain user id job created but i got warning..how to cleare this warning..?
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
July 4, 2011 at 4:08 am
Coolroof (7/4/2011)
i give owner name is domain user id job created but i got warning..how to cleare this warning..?Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
for the job you are creating check the @on_fail_step_id and set it to a value of an existing step you wish to use.
You could also use an SSIS package to move all your jobs too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 4:14 am
ok thanks friend i have another doubt i store csv file in my sql server how to send attached mail.. i have use this script that time i got mail queued message but i can't get mail.. how to resolve it..
July 4, 2011 at 4:56 am
check Books Online for configuring a database mail profile 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:01 am
As Perry says it could be an issue with exchange server. However did you check your junk folder?
July 4, 2011 at 5:09 am
Try sending the mail without the attachment. See if you get it. In case you get it, the attachment size may be too large.
If you don't get the mail. Try to check the dbmail configuration.
July 4, 2011 at 5:13 am
ya without attachemnt working and file size is below 10kb.. when i send run attachemnt script mail in queue but not get mail...
July 4, 2011 at 5:16 am
i haven't mentioned Exchange server, i pointed the OP to Books Online to gain information on how to enable and configure Database Mail on a SQL Server instance 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 7:54 am
i try alot but attach mail not sent..when i execute that script mail in queue only but i did't receive..
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply